EXCEL · DIGITAL WORKBOOK

Excel Lookup Basics

Match order product codes to a price table. Use XLOOKUP with an explicit missing-code result.

Who it’s for

Beginners building practical excel skills.

What you’ll practise

• Use XLOOKUP with an explicit missing-code result
• Test an unknown product code and verify it remains flagged

What you get

A worked example, guided exercise, independent practice and a review checklist. Delivered as a text file.