Browse categories
Explore
Fiverr Pro
English
$
USD
I will fix excel and google sheets formula errors
About this Gig
Formula showing #N/A, #REF!, #VALUE! or just the wrong number? Send me the file and tell me what it should do. I'll fix it, usually within 24 hours.
I can help with:
- VLOOKUP, XLOOKUP or INDEX MATCH not finding matches
- SUMIFS or COUNTIFS giving the wrong total
- QUERY, FILTER, IMPORTRANGE and ARRAYFORMULA in Google Sheets
- Date formulas that break
- Formulas that got messed up after rows were copied or deleted
- Dropdowns, data validation and conditional formatting
- A new formula from scratch if you tell me what you want it to do
Every delivery comes with a short note in plain English on what was wrong, so you can handle it next time.
Works with Google Sheets and Excel (Microsoft 365, 2019, 2021). On an older Excel version? Tell me and I'll use formulas that work there.
Please send a copy of your file, not the original, and remove anything private first.
Not sure if it's a quick fix? Message me a screenshot. If it's a 5 minute job, I'll tell you.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Excel
•
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Data validation
My Portfolio
FAQ
Do you need my original file?
No, a copy is better. In Google Sheets use File > Make a copy. For Excel just send the file. Remove anything private first.
Which package should I pick?
Basic is 1 formula or 1 error. Standard is up to 5 formulas, or one sheet with several problems. Premium is the fix plus a small automation. Not sure? Send me a screenshot first.
Do you work in Excel too, not only Google Sheets?
Yes, both. Tell me your Excel version. Some functions like XLOOKUP don't exist in older versions.
Will you explain what was wrong?
Yes. Every delivery has a short plain-English note.
Do you do VBA macros?
Small ones, yes, in Premium. For a bigger VBA project, message me first.
