Index and Match exercise tried the exact formula yet all results are N/A?
I tried the exact formula you recommend =INDEX('1.1 FY2016'!B$5:B$61,MATCH('2.1 Database'!$B61,'1.1 FY2016'!$G$5:$G$61,0)) and its not producing results. while the equivalent in the VLOOKUP previous exercise worked perfectly. This time it gives N/A to ALL values on the Database sheet. How could i fix that?
2 answers ( 0 marked as helpful)
Did you link to the correct sheet, please? We have FY 2015, FY2016, and FY2017 (if I'm not mistaken). Sometimes you'll not find a match for certain values if you're linking to the incorrect sheet for that particular code. Please feel free to send me a screenshot here. Thanks!
Yes sir here is the screenshot.
Submit an answer
Resolved: How did you select all the table rows and columns in one click?