I will fix excel formulas, vlookup, xlookup and google sheets formula errors
Excel and Google Sheets formula fixes and data cleanup
About this Gig
Get your broken VLOOKUP, XLOOKUP or SUMIFS formula working again, fixed in Excel or Google Sheets and explained in plain English.
I fix broken formulas and write new ones in Excel and Google Sheets:
- VLOOKUP / XLOOKUP / INDEX-MATCH that won't match
- SUMIFS, COUNTIFS, IF / IFS and nested logic
- FILTER, UNIQUE, SORT, QUERY (Sheets), ARRAYFORMULA
- Error-proofing with IFERROR and clean ranges
- Formulas that work in both Excel and Sheets where possible
Every delivery: your original kept safe, a checked working copy, and a short change log explaining each formula.
Before ordering, send your file (or a copy with dummy data) and an example of the correct result, so I can confirm the package.
Not included: VBA macros, Power BI, full dashboards, data entry. Big messy data cleanup is my other gig.
UK-based. AI may assist; every change human-checked.
Platform:
Excel
•
Google Sheets
Development technology:
Google Apps Script
•
Excel
Expertise:
Fixing
•
Formulas
•
Functions
•
Cleaning
•
Data validation
FAQ
Excel or Google Sheets?
Both. Tell me which app and version you use.
Do you need my real data?
No — a copy with dummy data works if the structure matches.
Do you do VBA macros?
No. Formulas and Google Apps Script only (see my other gig).
What if my file is very large or messy?
Message me first; data cleanup is my other gig.

