Excel Formula Help
What it can help with
- Writing formulas from scratch — VLOOKUP, XLOOKUP, IF, SUMIF, INDEX/MATCH, and more
- Fixing formula errors — #VALUE!, #REF!, #N/A, #NAME?
- Building and formatting pivot tables
- Setting up conditional formatting and data validation
- Creating and customizing charts
- Cleaning and organizing messy data
How to use it
Go to Productivity → Excel & Spreadsheets and click Open Excel Tool. This opens a chat tuned specifically for Excel — you get the exact formula you need, ready to copy and paste, with a plain-English explanation of how it works.
Upload a screenshot of your spreadsheet for even better results. The AI will analyze your actual data layout and give advice specific to what it sees.
Example questions
- "Write a VLOOKUP to match customer names from Sheet1 to IDs in Sheet2"
- "My SUMIF formula returns 0 but there should be matching data"
- "Create a formula to calculate a running total in column C"
- "How do I make a dropdown list that only allows values from another sheet?"