Cellwise · Looking things up

Find it with XLOOKUP

Look up a value by code, and handle codes that don’t exist.

You can pull any value from a table by its ID, and handle missing IDs cleanly.

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.