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.

While using Microsoft Excel for data ... the lookup range (A2:A5) and return the corresponding price from the result range ...

If you want to get the value of a particular cell in a data range, you can use the INDEX function. You just need to specify the row and column where it's located. The MATCH function in Excel ...