VLOOKUP for price
BeginnerWhen working with Excel, you’ll often need to look up a value in a table. In this example, we will pull a price from a product catalog using a product code. VLOOKUP is a quick way to do that.
VLOOKUP searches for a value in the first column of a table, then returns a value from another column in the same row.
The syntax of VLOOKUP looks like this:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Your task
Fill in the unit price for the order line:
- Look at the product catalog in cells A2:C6.
- Click cell B9 (Unit price).
- Use VLOOKUP to find the price for the product code in A9.
- Use the catalog range A2:C6 as your table.
- Return the value from the 3rd column of that table (the Unit price column).
- Use an exact match lookup (so the code must match exactly).
Need some help?
Hint 1
VLOOKUP needs four pieces: what to look up, where to look, which column to return, and whether it’s an exact match.
Hint 2
The lookup value is the product code in A9, and the table to search is the catalog in A2:C6.
Hint 3
You want the price from the 3rd column, and you should use an exact match (FALSE).
VLOOKUP for price
BeginnerWhen working with Excel, you’ll often need to look up a value in a table. In this example, we will pull a price from a product catalog using a product code. VLOOKUP is a quick way to do that.
VLOOKUP searches for a value in the first column of a table, then returns a value from another column in the same row.
The syntax of VLOOKUP looks like this:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Your task
Fill in the unit price for the order line:
- Look at the product catalog in cells A2:C6.
- Click cell B9 (Unit price).
- Use VLOOKUP to find the price for the product code in A9.
- Use the catalog range A2:C6 as your table.
- Return the value from the 3rd column of that table (the Unit price column).
- Use an exact match lookup (so the code must match exactly).
Need some help?
Hint 1
VLOOKUP needs four pieces: what to look up, where to look, which column to return, and whether it’s an exact match.
Hint 2
The lookup value is the product code in A9, and the table to search is the catalog in A2:C6.
Hint 3
You want the price from the 3rd column, and you should use an exact match (FALSE).