I will fix excel formulas, vlookup and google sheets errors

Pakistan

I speak Urdu, English, German, French, Spanish, Arabic, Catalan, Italian

Excel and Google Sheets Data Analyst, Formulas, Cleaning, Reports, Data Entry

I fix broken Excel and Google Sheets formulas (VLOOKUP, SUMIFS, INDEX-MATCH), clean messy data and turn sales or income records into simple reports. I also do data entry and PDF to Excel (text-based P...
About this Gig

Formula showing #N/A, #REF! or a wrong total? Send me your file and I will fix it, or build the formula you need, in Excel or Google Sheets.


WHAT I FIX

  • Broken or wrong formulas: VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS
  • Errors like #N/A, #REF!, #VALUE!, #DIV/0! and circular references
  • Totals that do not add up; dates or numbers stored as text
  • Long nested formulas rewritten to be shorter and easier to follow
  • Formulas that keep working when you add new rows
  • Dropdown lists and input checks where your sheet needs them


WORKS WITH

Excel (2016, 2019, 365), Google Sheets and .xlsx, .xls, .csv files. Formulas only: no macros or VBA.


HOW IT WORKS

  1. Send your file and tell me what is broken or what you want calculated.
  2. I review it and confirm the scope before I change anything.
  3. You get a tested file back, with notes as per your package.


ABOUT ME

I am a data analyst who works in spreadsheets daily, so I fix formulas the way I would want my own sheet fixed: simple, tested and easy to follow. Your data stays confidential and I always work on a copy.


Not sure which package fits? Message me a screenshot of your file and I will recommend one.

Platform:

Excel

•

Google Sheets

Development technology:

Excel

•

VLOOKUP

Expertise:

Fixing

•

Formulas

•

Functions

•

Cleaning

My Portfolio