I will fix excel formulas, vlookup, xlookup and google sheets formula errors

United Kingdom

I speak English

Excel and Google Sheets formula fixes and data cleanup

I fix broken and messy Excel and Google Sheets files. Send me the sheet showing #N/A or #REF!, the lookup that won't match, or the export full of duplicates and odd dates, and I'll return a checked wo...
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