Using the VLOOKUP Function
To use VLOOKUP to find the cost of different parts listed in the table array, type the name of a part into cell D2 and press the ENTER key on the keyboard.
The price will be displayed in cell E2.
- Click on cell D2 in your spreadsheet.
- Type Cog into cell D2 and press the ENTER key on the keyboard.
- The value $20.21 - the price of a cog - should be displayed in cell E2 since we asked VLOOKUP to return the price of any part name entered into cell D2.
- Type the name of other parts into cell D2 and their prices should be displayed in cell E2.