Practice File: Lookup_Reference_Functions_Practice.xlsx

Students should practice:

  1. VLOOKUP
  2. HLOOKUP
  3. XLOOKUP
  4. LOOKUP
  5. INDEX
  6. MATCH
  7. XMATCH
  8. CHOOSE
  9. ROW
  10. COLUMN
  11. ROWS
  12. COLUMNS

Final Output: A professional Employee & Product Lookup System using multiple lookup and reference techniques.

PreviousNext