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

Microsoft Excel is a powerhouse data management tool used in business, research, and education. Today, the application offers over 450 built-in functions ... VLOOKUP and the more cumbersome INDEX ...

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.