# 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
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
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

Experts Exchange Solution brought to you by