Repeat VLOOKUP formula...

Hi All,

This is my first post, so I hope it makes sense. I will try to explain this in as much detail as possable!

I have a VLOOKUP formula which links to an external Excel Workbook which I update each week. I simply copy the previous week’s formula and change the week-ending date to the new date. I use a Product ID for each product to look up against for Units, Sales and GP$. The problem is, I have my spreadsheet set out like this:

Week 1 Week 2

Product 1
Units
Sales
GP$
GP%

Product 2
Units
Sales
GP$
GP%

Etc…

I have to change the formula for Units, Sales and GP$ for Product 1 each week and then copy them to all the subsequent products, sometimes which may be made up of 50+.

Is there a way I can have a formula in Product 2+ that says to apply the same VLOOKUP formula as Product 1, but use the Product ID for Product 2 to lookup against?

Any help is greatly appreciated.

Cheers,
Benno.

It's not clear to me what you're looking for. Can you provide a better representation of your spreadsheet? It might help if you could attach a sample.