VLOOKUP / XLOOKUP help
Look up values without the pain.
chatgptgemini
Act as a spreadsheet tutor. I need to look up [value] from [table/range] and return [result] in [Excel/Sheets]. Give me the exact XLOOKUP (and a VLOOKUP/INDEX-MATCH alternative), explain the arguments, handle not-found cases, and warn about common mistakes. Data layout: [describe]
How to use this prompt
- Tap Copy prompt above.
- Replace the [bracketed] parts with your own details.
- Paste it into chatgpt, gemini.