Excel's VLOOKUP Function

By Ted French, About.com Guide

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.

Tutorial Steps

1. Click on cell D2 in your spreadsheet.


2. Type Cog into cell D2 and press the ENTER key on the keyboard.


3. 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.


4. Type the name of other parts into cell D2 and their prices should be displayed in cell E2.

Previous

• Using Excel's VLOOKUP Function
• Entering the Tutorial Data
• The VLOOKUP Dialog Box
• The Lookup Value Argument
• The Table Array Argument
• The Column Index Number Argument
• The Range Lookup Argument
• Using the VLOOKUP Function
• Excel VLOOKUP Error Messages

Next