VLOOKUP practice exercises
Look up a value in the first column of a table and return a value from another column, with an exact or approximate match.
- 1Look up a price with VLOOKUPIn G2, use VLOOKUP to find the Price of the code in F2. Ask for an exact match.
- 2VLOOKUP a number keyPremiumIn G2, use VLOOKUP to return the Salary of the employee whose ID is in F2.
- 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.
- 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).