Browse categories
Explore
Fiverr Pro
English
$
USD
I will fix your excel or google sheets formulas and errors
About this Gig
Seeing #REF!, #N/A or #VALUE! errors, or a formula that returns the wrong number? I find the cause, fix it and explain what was wrong so it doesn't happen again.
What I fix:
- VLOOKUP, XLOOKUP and INDEX/MATCH lookups that return #N/A
- SUMIFS, COUNTIFS and totals that don't add up
- QUERY, FILTER, ARRAYFORMULA and IMPORTRANGE in Google Sheets
- Dates, text and numbers stored in the wrong format
- Dropdowns, data validation and conditional formatting
- Slow or messy sheets that need cleaner logic
How it works:
1. Send your file or a copy of your Google Sheet and tell me which cells are wrong.
2. I confirm what's included before I start.
3. I fix and test everything against your own data.
4. You get the corrected file and a short note explaining each fix.
Works in Excel (Microsoft 365 and 2016+) and Google Sheets. Your original data is never deleted.
Not sure which package fits? Send me a screenshot of the error and I'll tell you.
Platform:
Excel
•
Google Sheets
Development technology:
Google Apps Script
•
Excel
•
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Data validation
Other Data Processing Services I Offer
FAQ
What counts as one formula?
One formula is one piece of logic, even if it is copied down a whole column. Fixing a broken VLOOKUP used in 500 rows counts as one.
Do you work in Excel or Google Sheets?
Both. Excel 2016 or newer, including Microsoft 365, and Google Sheets. If your file must work in both, tell me and I will use formulas that run in both.
Will you explain the fixes?
Yes. Every package includes a short note on what was wrong and what I changed, so you can maintain the sheet yourself.
Is my data safe with you?
I only use the file you share for your order, never copy your data elsewhere, and delete my working copies after delivery if you ask. You can also send a copy with sample data.
