Excel Lookup Formula Expert
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I have a spreadsheet that relies on VLOOKUP / HLOOKUP style formulas, and I want every lookup to return the right value the first time, even when the sheet grows or the ranges move. Your job is to jump into the file, build or correct the lookup formulas, and leave me with a clear, reliable workbook that I can maintain on my own later.
You’ll get a copy of the file as soon as we start. Please wire in the lookups, test them across a handful of sample cases, and annotate the cells (or add brief comments) so I understand the logic. If a dynamic alternative such as INDEX-MATCH or XLOOKUP would be more robust, feel free to implement it—just let me know why you chose it.
The work is complete when every lookup cell pulls the intended result without errors and I can follow the formula trail comfortably.
You’ll get a copy of the file as soon as we start. Please wire in the lookups, test them across a handful of sample cases, and annotate the cells (or add brief comments) so I understand the logic. If a dynamic alternative such as INDEX-MATCH or XLOOKUP would be more robust, feel free to implement it—just let me know why you chose it.
The work is complete when every lookup cell pulls the intended result without errors and I can follow the formula trail comfortably.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.