Sales Lookup Challenge
Use XLOOKUP on a deals list: find a deal by ID, handle an ID that does not exist, and pick the largest deal that fits a budget.
What you will practise: Use XLOOKUP for an exact match, for a clean 'not found' message, and for an approximate match that picks the nearest value without going over.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.