Exact VLOOKUP

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 16 of 28.

VLOOKUP(key, table, column_number, FALSE) searches the first column for an exact match. The result column is counted from the left edge of the table, starting at one. Exact lookup does not require sorting; missing keys produce an error.

E2 contains P2, A2 contains P3, B2 contains Pad, C2 contains 8, A3 contains P1, B3 contains Pen, C3 contains 3, A4 contains P2, B4 contains Clip, C4 contains 5.

Example: =VLOOKUP(E2,A2:C4,3,FALSE).

The matching code is in the third table row, and the third column supplies price 5.

Use FALSE for an exact VLOOKUP and count columns from the selected table's left edge.

The practice sheet highlights cells where you should enter formulas. The same formulas must work when the tests replace the input data.

Challenge

Easy

Look up code E2 in product table A2:C4, returning its price in F2. Codes are unique, the table is not sorted, and all test keys exist. Use exact VLOOKUP.

Enter formulas in the highlighted output cells: F2. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1