Cellwise · Looking things up

XLOOKUP’s hidden powers

Latest entries, partial names and whole records.

You can find the latest entry, match partial names and return whole records.

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.