I will fix your excel or google sheets formulas, errors and lookups

United States

I speak English

Excel and Google Sheets fixes, cleanup and Apps Script automation

Lanternhill Studio fixes the spreadsheet and website problems that eat your week. I clean messy Excel, Google Sheets and CSV data, repair broken formulas and lookups, automate Google Sheets with Apps ...
About this Gig

Get your broken Excel or Google Sheets formulas working, delivered in 1 day.

#REF!, #N/A, #VALUE!, totals that don't add up, or a lookup that returns the wrong row? I find the cause and fix it in your own file.

  • VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, IF/IFS, FILTER, QUERY, ARRAYFORMULA
  • Error cleanup and formulas that keep working when rows are added
  • A plain-English note on what was wrong and what I changed

Basic covers one formula. Standard covers one sheet; Premium covers a whole workbook.

Please share the file (or a copy with dummy data) and tell me what result you expect.

I use AI tools to help draft formulas, and I check everything myself.

Platform:

Excel

•

Google Sheets

Development technology:

VBA

•

Google Apps Script

•

Excel

Expertise:

Formatting

•

Fixing

•

Functions

My Portfolio