An curved arrow pointing right. Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP.
HowToGeek on MSN4mon
My 3 Favorite Ways to Use Data in Excel TablesINDEX(B2:D8,MATCH(G2,A2:A8,0),G3) When I press Enter, Excel correctly informs me that player C scored five goals in the third ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback