Browse categories
Explore
Fiverr Pro
English
$
USD
I will build advanced excel formulas xlookup, index match, sumifs
Excel Expert, Dashboards, Power Query and Advanced Formulas
I help businesses turn messy spreadsheets into clean, automated Excel systems.
Certified in Advanced Excel (Udemy, 17.5 hrs). Specialties: XLOOKUP/INDEX-MATCH, SUMIFS, Power Query, PivotTable dashboa...
About this Gig
Tired of manually searching and matching data across sheets? I'll build advanced Excel formulas that automate the lookups, calculations, and cross-referencing for you.
What I can build:
XLOOKUP / VLOOKUP / INDEX-MATCH (single or multi-criteria)
SUMIFS, COUNTIFS, AVERAGEIFS
Nested IF logic
Data validation with dependent (cascading) dropdowns
Formula troubleshooting if your current formulas are broken or slow, I'll fix them
I focus on formulas that are not just correct, but easy to maintain clearly structured so you (or your team) can update them later without confusion.
Send me your spreadsheet or describe the problem you're solving, and I'll recommend the best formula approach often before you even place the order.
Technology:
Excel
•
Google Sheets
Data type:
Numeric
•
Date
•
Phone
•
Free text
•
Custom
My Portfolio
FAQ
My formulas are giving errors — can you fix them instead of building new ones?
Yes, troubleshooting existing formulas is included under the Basic package.
Do you work with Google Sheets too?
Yes, most formulas work the same way — let me know which platform you're using.
What if my data structure changes later?
I build formulas to be as flexible as possible, and I'll explain how to adjust them yourself if your data grows or changes
