I will fix excel formulas, vlookup, xlookup, and spreadsheet errors
About this Gig
- Fix or rewrite VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, IF, and similar functions
- Repair #N/A, #REF!, #VALUE!, #DIV/0! and circular-reference issues
- Set up dropdowns and basic data validation so new rows stay consistent
- On the Premium package, add one small VBA macro for a repeating task you describe
I'll test each formula with a few of your rows before I deliver, and I leave your original sheet untouched so you can compare. I work in Excel (.xlsx). If your file is in Google Sheets, say so when you order and I'll tell you if this gig still fits.
How to order: attach the workbook, point me to the sheet and cells that are wrong, and tell me what the result should be. If a formula must not be changed, flag it. Basic covers up to 5 formulas and usually comes back the same day.
Your files stay private and are deleted after delivery.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Excel
•
VLOOKUP
Expertise:
Fixing
•
Formulas
•
Functions
•
Macros
•
Data validation
FAQ
What formulas do you work with?
VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, IF, and similar Excel functions. Tell me the result you want if you're not sure of the function name.
Can you write a macro?
Yes, on the Premium package: one small VBA macro for a repeating task you describe. Larger automation should be a custom offer.
Do you work in Google Sheets?
I can look at a Sheets file and tell you if this gig still fits. I work in Excel (.xlsx) by default.
Will you change formulas I need to keep?
No. Tell me which cells must stay as they are, and I'll leave them alone.
What do I need to send?
The workbook, the sheet name, the cells that are wrong, and a short note on what the result should be. Please attach the file in this Fiverr order.
What files can I send?
Please attach the Excel workbook in this Fiverr order. I don't open .html, .exe or zip files, or links outside Fiverr.
Is my data kept private?
Yes. Your files are only used to complete your order and are deleted after delivery.

