I will fix excel formulas, xlookup, vlookup and pivot table errors
Excel VBA Automation and Reporting Specialist
About this Gig
Wrong totals, broken lookups or Excel errors? I will repair the agreed formulas and explain the changes clearly.
I work with XLOOKUP, VLOOKUP, INDEX/MATCH, IF, SUMIFS, COUNTIFS, date/text functions, broken references and PivotTable source or refresh issues.
Basic: up to 6 distinct simple formula patterns in 1 workbook.
Standard: up to 10 simple or moderate formula patterns across 3 sheets, 1 PivotTable repair and light formatting.
Premium: up to 10 formula patterns across 5 sheets, 2 PivotTable repairs, 1 simple VBA cleanup/report task with 1 button for Windows Excel, and a short walkthrough.
Every package includes an editable corrected file, checks against expected results, written fix notes and 2 revisions. Premium includes 3 revisions and editable VBA code. A formula copied down a column counts as one pattern.
Please send your file, affected cells, expected results and Excel version before ordering. Complex models, external integrations and corrupt-file recovery need separate assessment. Revisions cover the agreed issues; new work is quoted separately.
Platform:
Excel
Development technology:
Excel
Expertise:
Fixing
•
Pivot tables
•
Formulas
•
Functions
My Portfolio
FAQ
Can you fix #N/A, #VALUE! and #REF! errors?
Yes. I will inspect the source data, expected result and formula logic, then test the corrected result before delivery.
How are formulas counted?
A distinct formula pattern counts once, even if copied down many rows. Basic includes 6 patterns; Standard and Premium include 10. Please send complex formulas first so I can confirm the scope.
What should I send with my order?
Send the workbook, affected sheet names and cells, examples of the correct result, and your Excel version. An anonymized sample with the same structure is fine.
What is included in PivotTable repair?
Standard includes 1 and Premium 2 agreed source-range or refresh repairs. New dashboards, external data models and redesigns need a separate quote.
What VBA task does Premium include?
One simple cleanup or report task in Windows desktop Excel, with one button, editable code and instructions. Mac, web Excel, external integrations or complex existing macros need assessment first.
What do revisions and confidentiality cover?
Revisions adjust the agreed fixes, not new features. Please anonymize sensitive samples; any external tool requiring disclosure of confidential data will be discussed with you first.

