Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. Lookups

VLOOKUP Practice Exercises: Exact, Approximate, Cross-Sheet and #N/A

Exact and approximate matches, lookups across sheets, and IFERROR for missing keys.

5 exercises, about 31 min

  1. 31Pull the unit price with VLOOKUP (exact match)Beginner~5 minBeginner, ~5 min
  2. 32Look up a customer tier from another sheetBeginner~5 minBeginner, ~5 min
  3. 33Shipping cost bands with approximate VLOOKUPIntermediate~7 minIntermediate, ~7 min
  4. 34Show "Not found" instead of #N/AIntermediate~7 minIntermediate, ~7 min
  5. 35Pick the month column with MATCHIntermediate~7 minIntermediate, ~7 min