In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Lookups With XLOOKUP, INDEX/MATCH or VLOOKUP
Prompt
App and version: {{SPREADSHEET_APP}}
Lookup table (sheet name, headers, three sample rows): {{LOOKUP_TABLE}}
Where the key values live and what I want pulled back: {{LOOKUP_GOAL}}
Known data problems (duplicates, missing keys, mixed text/number IDs): {{KNOWN_ISSUES}}
Do this:
1. Recommend XLOOKUP, INDEX/MATCH or VLOOKUP for my situation and give two sentences on why. If my version lacks XLOOKUP, say so and don't use it.
2. Write the formula with exact match, using whole-column references only if my version handles them efficiently; otherwise bounded ranges.
3. Wrap it so a missing key shows a clear message rather than #N/A, and explain what that hides.
4. Show how to return several columns at once if it applies.
5. Tell me how to find keys that fail to match (a one-cell count I can run).
State your assumptions. End with a three-row test using my sample.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Lookups With XLOOKUP, INDEX/MATCH or VLOOKUP” is a free prompt for ChatGPT in the Productivity category, 159 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{SPREADSHEET_APP}}, {{LOOKUP_TABLE}}, {{LOOKUP_GOAL}}, {{KNOWN_ISSUES}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 7 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.