Finding last match using INDEX MATCH

With the following formula I am finding the first match:

=IFERROR(INDEX('[Cartography_12DEC2013_Oct21_Test.xlsm]Cartography'!$I$2:$I$675,MATCH(M2,'.[Cartography_12DEC2013_Oct21_Test.xlsm]Cartography'!$H$2:$H$675,0)),"")

I would like to change the formula so that it finds the last match.

Thanks,
Andrea
AndreamaryAsked:
Who is Participating?
 
barry houdiniCommented:
For "last match" try this formula with LOOKUP

=IFERROR(LOOKUP(2,1/('[Cartography_12DEC2013_Oct21_Test.xlsm]Cartography'!$H$2:$H$675=M2),'[Cartography_12DEC2013_Oct21_Test.xlsm]Cartography'!$I$2:$I$675),"")

regards, barry
0
 
David L. HansenProgrammer AnalystCommented:
0
 
AndreamaryAuthor Commented:
Worked perfectly, thanks! And appreciate the very quick turnaround...
Cheers,
Andrea
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.