Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Test

Excel lookup test: VLOOKUP, XLOOKUP, INDEX MATCH

No tips this time. Answer the questions and see your score: 70% or more and you've passed.

  1. Price of a Latte. VLOOKUP searches the first column of a table and returns a value from the same row.
    You can type the value you look for straight into the formula, in quotes. Find the price of a Latte in F2
  2. Shipping cost. With TRUE as the last argument, VLOOKUP doesn't need an exact match. It takes the last row that is not larger than your value. The first column must be sorted from small to large. Find the shipping cost for the 7 kg parcel in E2
  3. Price by product code. XLOOKUP looks for a value in one column and returns the value from the same row in another column. Find the price of product P-104 in F2
  4. Sales for a month. HLOOKUP is VLOOKUP turned on its side: it looks along the top row and returns a value from a row below. Look up the sales for the month in A6, in B6
  5. Dina's department. MATCH finds the row of a value, and INDEX returns what's in that row of another column. Together they look up anything. Find the department of Dina in F2
  6. Every region once. UNIQUE removes the duplicates from a list. The answer spills into the cells below by itself. List every region once, starting in C2
  7. Everyone in Sales. FILTER returns every row that meets a condition. The answer spills into the cells below by itself. List everyone who works in Sales, starting in D2
  8. VLOOKUP.

← All lessons