I was wondering if anyone can help me with vlookup that use"match index formulas"?

Or using sumproduct with match and index?


Thank,

Hi Angie,

So here's a starting point.

This VLOOKUP formula:
=VLOOKUP(F2,A2:C4,3,0)

can be also be done using INDEX and MATCH like this:
=INDEX(C2:C4,MATCH(F2,A2:A4,0))

Does that help, or do you have something more particular in mind?


MrExcel recently did a VLOOKUP Week, where lots of people around the world got together and wrote a load of articles on VLOOKUP, INDEX, MATCH etc etc

Might be worth checking out some of the articles; you can find them here (navigate using the categories section on the right hand side):
http://vlookupweek.wordpress.com/

__________________
Colin

RAD Excel Blog