Suggest an editFor: How to Use XLOOKUP in ExcelLeave this empty What version are you on? (for example Windows 11 24H2, macOS 26, iOS 18, Chrome 140)Which step?1. Type the formula2. Handle a missing value3. Look up in any direction4. Return several columns at once5. Find the last matchA step is missingSomething else on the pageWhat should it say?Screenshot (optional, up to 4 MB)Your email (optional, only if you want a reply)Send suggestionNo account needed. Suggestions are reviewed before anything changes on the site.