Excel VLOOKUP Formula Assistance
Budget: ₹1,500 – ₹12,500 INR
I’ve hit a road-block while building an Excel model and need a fresh set of eyes on my VLOOKUP setup. The worksheet pulls data from several tabs, and I’m getting mismatches and #N/A errors that I can’t pin down.
Your task is to review the file, correct or redesign the VLOOKUP logic, and return a clean workbook that produces accurate results every time new data is added. If you see a smarter alternative—such as INDEX-MATCH or a dynamic array approach—feel free to implement it, but please keep the sheet user-friendly so my team can understand what changed.
I’ll share the spreadsheet and a brief note on what each column should display. When you reply, highlight similar projects you’ve completed or any deeper experience you have troubleshooting complex lookup formulas. No long proposal needed—clear evidence of experience will do.
Deliverable:
• Updated workbook with fully functioning lookup formulas and a short comment block or notes sheet explaining the adjustments.
Your task is to review the file, correct or redesign the VLOOKUP logic, and return a clean workbook that produces accurate results every time new data is added. If you see a smarter alternative—such as INDEX-MATCH or a dynamic array approach—feel free to implement it, but please keep the sheet user-friendly so my team can understand what changed.
I’ll share the spreadsheet and a brief note on what each column should display. When you reply, highlight similar projects you’ve completed or any deeper experience you have troubleshooting complex lookup formulas. No long proposal needed—clear evidence of experience will do.
Deliverable:
• Updated workbook with fully functioning lookup formulas and a short comment block or notes sheet explaining the adjustments.