VLOOKUP Formula Help Needed
Budget: £20 – £250 GBP
I’m working in Microsoft 365 Excel and have a single, well-structured product table. I simply need an extra pair of expert hands for about an hour so the formulas are done right the first time.
Here’s exactly what I’m after:
• Locate a specific product key with VLOOKUP.
• Once the key is found, drop some rows down in the same table and pull five data points from that row.
• Paste those five values back into matching columns on my main sheet.
The attached workbook spells out cell references and the five data points to bring over, so you’ll have a clear roadmap before you start. I’m happy to jump on a quick call or screen-share to walk through the file; after that, just deliver the working formulas and a short note explaining your steps so I can maintain them later.
If you’ve got solid VLOOKUP (or XLOOKUP, INDEX/MATCH) skills and a free hour today, this should be quick, clean work.
Here’s exactly what I’m after:
• Locate a specific product key with VLOOKUP.
• Once the key is found, drop some rows down in the same table and pull five data points from that row.
• Paste those five values back into matching columns on my main sheet.
The attached workbook spells out cell references and the five data points to bring over, so you’ll have a clear roadmap before you start. I’m happy to jump on a quick call or screen-share to walk through the file; after that, just deliver the working formulas and a short note explaining your steps so I can maintain them later.
If you’ve got solid VLOOKUP (or XLOOKUP, INDEX/MATCH) skills and a free hour today, this should be quick, clean work.
Related categories:
Visual Basic
Data Processing
Excel
Mathematics
Excel VBA
Excel Macros
Data Analysis
Microsoft 365