Excel - Vlookup. What is that?

Vlookup is an useful feature of Excel that simplifies your task of searching for information from a long list.

Here is a simple example.

• You have a product list from A1 to C6.
• This productblist can be very long, only requirement is that Item Number (column A) must be unique.

• You want to display the corresponding Item in cell B10  for Item Number XY 1003,
• Place the pointer in cell B10, type the formula as above and press Enter.

How the formula works

• Vlookup search a vertical list (A2:C6) for a unique lookup value (A10) and return the corresponding value from the second (2) column of the list.

Now type a similar formula for cell C10.

Tip: You just have to change the number 2 to 3, as Price is in the third column.