AI Writes Excel Formulas For You — ChatGPT + Copilot Guide (2026)
Stop memorizing Excel formulas — describe your task and AI writes the formula. ChatGPT prompts for VLOOKUP, IF, XLOOKUP, fixing errors, and more.
You don't need to memorize Excel formulas anymore. Describe what you want in plain Hindi/English — AI writes the exact formula. Here's how office workers save hours daily.
How It Works
Instead of learning =VLOOKUP(A2,B:D,2,0) syntax, you just say:
"I have names in column A and sales in column B.
Write a formula to find total sales for 'Rahul'."
→ AI gives you =SUMIF(A:A,"Rahul",B:B) — copy, paste, done.
Step 1 — Describe Your Data Layout
The key info AI needs:
- Which columns have what data
- What you want the result to be
- Example rows help a lot
Column A: Product names
Column B: Quantity sold
Column C: Price
I need total revenue (qty × price) in column D, summed up in a cell below.
Step 2 — Common Tasks + Prompts
Lookup:
Find price in column C where column A matches the value in E2.
→ =VLOOKUP(E2,A:C,3,0) or =XLOOKUP(E2,A:A,C:C)
Conditional sum:
Sum column B only where column A says "Paid".
→ =SUMIF(A:A,"Paid",B:B)
Conditional count:
Count how many rows have "Delhi" in column D.
→ =COUNTIF(D:D,"Delhi")
Date work:
How many days between dates in A2 and B2?
→ =B2-A2
Step 3 — Fix Errors with AI
Got #N/A or #VALUE!? Paste it:
This formula gives #N/A: =VLOOKUP(A2,D:F,2,0).
My lookup value is in A2, the table is D to F. What's wrong?
AI will spot it's likely a wrong column number or missing match.
Step 4 — Complex Tasks
I have employee names in A, departments in B, salaries in C.
Give me average salary per department.
→ =AVERAGEIF or PivotTable guidance.
Step 5 — VBA/Macros (No Coding Needed)
Write Excel VBA code that copies all rows where column C
is empty to a new sheet called "Pending".
Copy → Alt+F11 → paste → run. You just automated Excel with zero coding knowledge.
Real Office Use Cases
- Data cleaning — "remove duplicates where column A matches"
- Reports — "summarize monthly sales by product"
- Formatting — "highlight cells where value > 1000"
- Extraction — "pull text before the @ in emails"
Which AI to Use
- ChatGPT free — works for 95% of formulas
- Microsoft Copilot — built into Excel (needs Microsoft 365 subscription)
- Gemini — also writes formulas, works in Google Sheets too
FAQ
Do I need to know any Excel? Basic — know your columns and what you want. AI handles syntax.
Does it work in Google Sheets? Yes — most formulas are identical. Say "Google Sheets" in your prompt to be safe.
What if the formula doesn't work? Paste the error + your data layout back. AI fixes it 9/10 times.
Bottom Line
Excel formulas are now a description away. The skill isn't memorizing syntax — it's clearly explaining your data. Do that, and you're more productive than people who've used Excel for years.
What's Your Reaction?
