ChatGPT Text prompt

Learn VLOOKUP / XLOOKUP With Your Own Data

A patient, step-by-step lesson that teaches lookups using an example from your own work.

Free No login · Commercial use allowed · Copy and use
  • 0 times copied
  • 82 words
  • Updated November 10, 2026

The prompt

Teach me [VLOOKUP / XLOOKUP] like a patient tutor.
I work as a [your job]. Create a small example table from my kind of work (two tables: one master list and one where I need to fetch data).
1. Explain the formula in simple words with a real-life analogy.
2. Walk me through writing it step by step on the example.
3. Show 3 common errors (#N/A, wrong column, approximate match) and how to fix them.
4. Give me 3 practice exercises with answers hidden at the end.

What to write in the [brackets]

ReplaceWith
[VLOOKUP / XLOOKUP]Which one to learn
[your job]e.g. accountant, store manager, HR

How to use this prompt

  1. Click "Copy prompt" above.
  2. Open ChatGPT (the free version works for most prompts).
  3. Paste the prompt and replace every part in [square brackets] with your own details.
  4. Send it, then ask follow-up questions to improve the answer (e.g. "make it shorter", "write it in Hindi").
  5. Check facts, prices and numbers before you use the result with customers.

Tips for better results

  • Type the formulas yourself — copying won't help you learn.
  • Ask for INDEX-MATCH next.

Try these variations

After the first answer, send one of these as a follow-up message:

  • Teach me pivot tables the same way.

FAQ

Does this prompt work only with ChatGPT?

No. It works in ChatGPT, Gemini, Claude and most other AI chat tools. Results vary a little between tools.

Is this prompt free to use for my business?

Yes. All prompts in the Cracckk Prompt Library are free, including for commercial work. Always check AI output before you publish or send it.

Can I use it in Hindi or another Indian language?

Yes. Add a line like "Reply in Hindi" or "Use Hinglish" at the end of the prompt.