I will fix excel formulas, vlookup, xlookup, and spreadsheet errors

United States

I speak English

Excel and CSV data cleaning, deduping and formatting

I'm Seth, and I clean up messy spreadsheets. Duplicates, dates typed five different ways, names in all caps, #N/A errors, tabs that should be one table: send the file and you'll get back one clean, co...
About this Gig
Broken formula? #N/A, #REF!, or a VLOOKUP that suddenly stopped working? Send the file and I'll fix it, or write the formulas you need, and leave a short note so you can keep using the sheet.

What I can do:
  • 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