Cellwise · Looking things up

Two-way lookups

Read a rate card, and match on two columns.

You can read any grid by its labels, and look up rows that need two keys.

This lesson has 3 steps of hands-on practice in a live spreadsheet. Every formula you write is also tested on data you haven’t seen, so you know it really works.