PracticeExcelSign in
Google Sheets practice exercises

VLOOKUP practice in Google Sheets

VLOOKUP looks up a value in the first column of a table and returns a value from another column. Google Sheets calls the last argument is_sorted, but it works as in Excel: FALSE for an exact match, and TRUE or left out for the nearest smaller value in a sorted column.

Start the first exercise
  1. 1Look up a price with VLOOKUPIn G2, use VLOOKUP to find the Price of the code in F2. Ask for an exact match.
  2. 2VLOOKUP a number keyPremiumIn G2, use VLOOKUP to return the Salary of the employee whose ID is in F2.
  3. 3VLOOKUP with an approximate matchPremiumIn E2, find the commission rate for the sales in D2. The table lists where each band starts, so use VLOOKUP with TRUE for an approximate match.
  4. 4Bring prices into an order listPremiumIn C2, look up the price of the code in B2 in the price table E2:F5. Lock the table with $ so the formula can be filled down the order list: VLOOKUP(B2,$E$2:$F$5,2,FALSE).

Functions in this topic

Questions

Why does VLOOKUP return #N/A in Google Sheets?

The value is not in the first column of the range. Check for extra spaces, numbers stored as text and a missing FALSE at the end, just as in Excel.