Ledger DrillBeta
Log inJoin for free

Looking things up

Fetch a price, a name or a credit limit from a list with VLOOKUP, XLOOKUP, and INDEX with MATCH. Then fix the lookups that fail.

Premium5 rooms42 questions44 min
See the first roomHow VLOOKUP works

Rooms in this module

  1. How VLOOKUP works8 min, easyPremium
  2. VLOOKUP: exact match or nearest match?8 min, easyPremium
  3. How XLOOKUP works9 min, easyPremium
  4. How INDEX and MATCH work together9 min, mediumPremium
  5. How to fix a lookup that returns #N/A10 min, mediumPremium

How this works

Each room answers one problem. A task is a few lines of reading, then questions you answer in the books: post to an account, type a figure, sort, match or write a journal. Every answer is marked at once, with the rule behind it. There are no videos.

Questions

How many rooms and questions are in Looking things up?

5 rooms and 42 questions. Every question is marked at once.

How long does it take?

About 44 minutes in all. A room takes 8 to 10 minutes, so you can do one at a time.

Is it free?

No. These rooms need Premium. Each room shows the start of its first task before you pay.

What should I do first?

Making decisions. It is the module before this one in Spreadsheets for the office.