I will fix excel formulas, vlookup and google sheets errors
Excel and Google Sheets Data Analyst, Formulas, Cleaning, Reports, Data Entry
About this Gig
Formula showing #N/A, #REF! or a wrong total? Send me your file and I will fix it, or build the formula you need, in Excel or Google Sheets.
WHAT I FIX
- Broken or wrong formulas: VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS
- Errors like #N/A, #REF!, #VALUE!, #DIV/0! and circular references
- Totals that do not add up; dates or numbers stored as text
- Long nested formulas rewritten to be shorter and easier to follow
- Formulas that keep working when you add new rows
- Dropdown lists and input checks where your sheet needs them
WORKS WITH
Excel (2016, 2019, 365), Google Sheets and .xlsx, .xls, .csv files. Formulas only: no macros or VBA.
HOW IT WORKS
- Send your file and tell me what is broken or what you want calculated.
- I review it and confirm the scope before I change anything.
- You get a tested file back, with notes as per your package.
ABOUT ME
I am a data analyst who works in spreadsheets daily, so I fix formulas the way I would want my own sheet fixed: simple, tested and easy to follow. Your data stays confidential and I always work on a copy.
Not sure which package fits? Message me a screenshot of your file and I will recommend one.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Fixing
•
Formulas
•
Functions
•
Cleaning
My Portfolio
FAQ
What kind of spreadsheets do you work with?
I work with Excel and Google Sheets files. If your file is in another format (like CSV), send it over and I'll let you know if I can work with it.
What formulas can you fix or build?
VLOOKUP, XLOOKUP, INDEX-MATCH, IF and nested IF, SUMIFS, COUNTIFS, and more. If you're not sure what you need, just describe what you want to calculate and I'll figure out the right formula.
Do I need to explain exactly what's wrong with my file?
No. Just tell me what you expected to happen and what's happening instead. I'll find the cause and fix it.
Will my formulas break again when I add new rows or data?
I build formulas so they keep working as your data grows, using clean logic and proper references. I'll also tell you if there's anything to watch for when adding new data.
Can you fix my formulas without changing my layout or design?
Yes. By default I keep your layout, formatting, and structure exactly as they are and only touch the formulas. If I think a change would help, I'll ask you first.
Is my data safe?
Yes. Your file is used only for your order and is never shared with anyone. I'm also happy to work on a copy with sensitive details removed if you prefer.
How long will it take?
Most fixes are done within the delivery time shown on your package. For large or complex files, message me first and I'll give you an exact timeline.
What if I'm not happy with the result or something still doesn't work?
Message me and I'll fix it. Every delivery includes testing, and I'll revise until the formulas do what you asked for within the agreed scope.
Do you write macros or VBA?
No. This gig covers formulas only: fixing, building and simplifying them in Excel and Google Sheets. I do not write macros, VBA or Apps Script. If you are unsure whether your task needs one, message me before ordering.
How many formulas do I need to order?
Count the columns or cells that show wrong results. One formula copied down a column counts as one formula. Not sure? Send me a screenshot and I will recommend the right package. You can also add the Additional formula extra.

