Write a VLOOKUP formula using ChatGPT

Step-by-step walkthrough

1. 1

   Describe your data

   Open ChatGPT (or any AI chat). Briefly describe your two sheets: what columns they have and what you want to match.

   💬 Prompt to use:

   I have a sheet called "Orders" with columns: Order ID, Customer ID, Amount. I have another sheet called "Customers" with columns: Customer ID, Customer Name. Write a VLOOKUP in Orders to pull in the Customer Name based on Customer ID.

2. 2

   Paste the formula

   Copy the formula ChatGPT gives you. Click the cell in Excel where you want the result, then paste.

   💡 Pro tip: Ask it to add an IFERROR wrapper so blank cells show "" instead of #N/A.
3. 3

   Drag to fill

   Click the small green square at the bottom-right of the cell and drag down to apply the formula to all rows.

4. 4

   Debug if needed

   If you get an error, paste it back into ChatGPT and ask "Why am I getting this error?" — it will diagnose and fix it.