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 is a small studio that helps with spreadsheet and website problems. I fix broken Excel and Google Sheets formulas, clean up and categorize messy data, build Google Apps Script autom...
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