Browse categories
Explore
Fiverr Pro
English
$
USD
I will fix or create excel and google sheets formulas
About this Gig
Excel formula returning an error? Need VLOOKUP, XLOOKUP, SUMIFS or a Google Sheets formula that just works? I'll fix or write the formulas you need, test them on your data, and explain how each one works so you can maintain it.
What I do:
Fix #N/A, #VALUE!, #REF! and other formula errors
XLOOKUP, VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, FILTER, UNIQUE
Date math, text cleanup and IF logic
Conditional formatting and dropdown lists (Sheet Upgrade and Full Tracker)
A simple summary sheet (Full Tracker)
How it works:
1. Send your file and describe what the formula should do
2. I build and test it on your data, including blank and tricky rows
3. You get the working file plus a plain-English explanation of every formula
Not included: VBA, macros, Apps Script or Power Query.
Not sure how many formulas you need? Send me a message. I reply within the hour during the day.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Data validation
FAQ
Excel or Google Sheets?
Both. Tell me which one you use in the order requirements and I will build and test the formulas there.
What counts as one formula?
One formula written once and filled down a column counts as one. Different formulas in different columns count separately.
Do you write macros, VBA or Apps Script?
No. I work with formulas, conditional formatting, dropdowns and sheet structure only.
Will I understand how it works?
Yes. Every formula comes with a short plain-English explanation so you can edit it later.
What if a formula breaks on new data?
Tell me what changed. Your package includes revisions, and I test on blank and tricky rows before delivering.
Do you use AI tools?
I use AI-assisted tools for speed, then test every formula on your actual data by hand. If you need no AI used at all, please message me before ordering.
Is my data kept private?
It's only used for your order. If your file has personal details, send a copy with sample rows instead.
Which Excel version do you support?
Excel 365, 2021, 2019 and 2016, plus Google Sheets. Tell me your version and I will only use functions that work in it, for example INDEX/MATCH instead of XLOOKUP on older Excel.
