VLOOKUP Function Example

Associated Files Download Links

Let’s take a look at the VLOOKUP function. In our example we have a company with a list of part numbers, along with information about them. Let’s asssume this list is very long, and they would like to enter a part# in a cell and have it return information about that part quickly.

This picture shows our desired result. In the orange cell we enter a part number, then the location and price will automagically display