Browse categories
Explore
Fiverr Pro
English
$
USD
I will create and fix excel formulas, xlookup, vlookup and pivot tables
Excel Data Matching, Cleaning and Python Automation
I help small businesses and analysts fix spreadsheet problems fast.
Send me two files that should match - orders vs payments, stock vs records, a system export vs accounting - and I will find the mis...
About this Gig
Stuck on a broken VLOOKUP, a formula full of #N/A, or a pivot table that will not add up? Send me your file and I will fix it or build exactly what you need.
What you get: working formulas in your own file (XLOOKUP, VLOOKUP, INDEX/MATCH, IF/IFS, SUMIFS, COUNTIFS), errors like #N/A, #REF! and #VALUE! found and fixed, pivot tables that summarise your data the way you need, and a short note explaining how each formula works.
How it works:
Step 1: Send your file (or a copy with sample data) and describe the result you want.
Step 2: I build or fix the formulas directly in your workbook.
Step 3: You get the file back, plus a short explanation.
Why me: I test every formula on your real layout before delivery. You keep full control, with no macros or add-ins unless you ask for them. Clear explanations, so you can maintain the sheet yourself.
Message me with your file and I will reply with a fixed price and delivery date.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Python
•
Excel
•
VLOOKUP
Expertise:
Fixing
•
Pivot tables
•
Formulas
My Portfolio
FAQ
My formula still shows #N/A - can you fix that?
Yes. #N/A, #REF!, #VALUE! and wrong totals are the most common fixes I do.
Do you work with Google Sheets?
Yes. Most formulas work in both; I tell you if anything needs a Sheets-specific version.
Will you explain how the formulas work?
Yes. Every delivery includes a short note, so you can update the sheet yourself.
Is my data kept private?
Yes. Your file is used only for your order and deleted from my computer 7 days after delivery.
What if my version of Excel has no XLOOKUP?
I use VLOOKUP or INDEX/MATCH instead, so it works in older Excel.
