Cellwise · Looking things up

VLOOKUP and INDEX/MATCH

The lookups you’ll meet in other people’s spreadsheets, and in interviews.

You can read and write the lookups used in most existing workbooks.

This lesson has 4 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.