I will fix excel formulas, vlookup, xlookup and spreadsheet errors
Business Analyst, Functional Tester, Excel and Data Specialist
About this Gig
Excel formula not working? Ill help you fix it!
Getting #N/A, #VALUE!, #REF! or incorrect results in your spreadsheet?
I will troubleshoot and fix your Excel or Google Sheets formulas so you can get back to work.
I can help with:
- VLOOKUP, XLOOKUP and INDEX/MATCH
- IF, SUMIF, COUNTIF and other formulas
- Formula errors and incorrect results
- Broken cell references
- Spreadsheet troubleshooting
Why work with me?
I have professional experience working with Excel, data and business processes. I focus on practical solutions and clear communication.
Not sure which package you need?
Send me a message describing your problem before ordering. Ill help you choose the right option.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Power Query
•
Excel
•
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Data validation
My Portfolio
Other Data Processing Services I Offer
FAQ
Can you fix XLOOKUP or VLOOKUP errors?
Yes. I can troubleshoot lookup formulas and correct matching ranges, references and logic.
What if I do not know which formula I need?
That is fine. Explain what you want the spreadsheet to do, and I can suggest and create the appropriate formula.
Can you fix formulas across multiple sheets?
Yes. I can work with formulas and references across multiple worksheets.
Can you fix #N/A, #VALUE!, #REF! or similar errors?
Yes. I can diagnose common Excel and Google Sheets formula errors and correct the underlying issue.
Can you help with nested IF, SUMIFS or COUNTIFS formulas?
Yes. I can fix or create more advanced formulas using IF, SUMIFS, COUNTIFS, INDEX/MATCH and similar functions.
Do you also work with Google Sheets?
Yes. I work with both Microsoft Excel and Google Sheets.
What counts as one formula?
One formula means one unique formula or logic issue. If the same corrected formula needs to be copied down a range, that usually counts as one formula.
Is my data kept confidential?
Yes. I will only use your file to complete the requested work and will treat your data confidentially.

