Last answered:

24 May 2023

Posted on:

24 May 2023

0

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)
Posted on:

24 May 2023

0

Hello,

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!

Posted on:

24 May 2023

0

Yes sir here is the screenshot. 

Submit an answer