← Back to the activity

Grade 10 Computer Science — Looking a value up in a table

Read a VLOOKUP: find the row its search value matches, and take the answer from the column its number names.

Name: ________________________

  1. 1.A lookup for map over a four-row table shows 60. The rows of the table are then shuffled so that the map row is the first one, and the same formula is run again over the same range. What number does it show now?

  2. 2.A table sits in A1:B4, with pen, bag, cup and map down column A. A lookup for cup shows 25. Which cell of the sheet is that 25 actually sitting in?

  3. 3.A table sits in A1:B5. Column A holds pen, bag, cup, map and tin; column B holds 14, 9, 31, 6 and 22. Match each value being looked for to the number a lookup of column 2 shows for it.

    • "pen"
    • "cup"
    • "tin"
    • "bag"
    • "map"
    • 31
    • 22
    • 14
    • 9
    • 6

  4. 4.The first column of this table holds numbers rather than words: A1:A3 hold 101, 102 and 103, and B1:B3 hold 40, 55 and 70. What number does this formula show?

    =VLOOKUP(102, A1:B3, 2, FALSE)

  5. 5.A sheet holds a table in A1:C4. Column A holds pen, bag, cup and map; column B holds 10, 40, 25 and 60; column C holds 5, 2, 9 and 4. What number does this formula show?

    =VLOOKUP("bag", A1:C4, 3, FALSE)

  6. 6.This table has the same name in it twice by mistake. Column A holds pen, bag, pen and cup, and column B holds 10, 40, 25 and 60. A lookup goes down the first column and stops at the first row that matches. What number does this formula show?

    =VLOOKUP("pen", A1:B4, 2, FALSE)

  7. 7.Two lookups into the same table are multiplied together here. Column A holds pen, bag, cup and map; column B holds 10, 40, 25 and 60; column C holds 5, 2, 9 and 4. What number does this formula show?

    =VLOOKUP("cup", A1:C4, 2, FALSE) * VLOOKUP("cup", A1:C4, 3, FALSE)

  8. 8.A table sits in A1:B4, with pen, bag, cup and map down column A and 30, 12, 45 and 7 beside them in column B. Put these lookups in order of the number each one shows, smallest first.

    • =VLOOKUP("pen", A1:B4, 2, FALSE)
    • =VLOOKUP("bag", A1:B4, 2, FALSE)
    • =VLOOKUP("cup", A1:B4, 2, FALSE)
    • =VLOOKUP("map", A1:B4, 2, FALSE)

Answer key — Grade 10 Computer Science — Looking a value up in a table

  1. 1. 60
  2. 2. B3
  3. 3. "pen" → 14; "cup" → 31; "tin" → 22; "bag" → 9; "map" → 6
  4. 4. 55
  5. 5. 2
  6. 6. 10
  7. 7. 225
  8. 8. 1. =VLOOKUP("map", A1:B4, 2, FALSE) 2. =VLOOKUP("bag", A1:B4, 2, FALSE) 3. =VLOOKUP("pen", A1:B4, 2, FALSE) 4. =VLOOKUP("cup", A1:B4, 2, FALSE)