V
vickya
Hi there
I am trying to create a formula which will use a product code typed into a
cell in the same sheet, look up this code in a separate file, and give me the
sales figure which is offset from this code.
I.e. (if this helps)
This is the formula I have at the moment just using the other file:
=OFFSET('[Budget Tracker Master Copy 2010.xlsm]Total by Product'!$EJ$5,739,3)
but I want the code which is in EJ5 to come from my current sheet which is
in cell B8.
The range to look up in the Budget Tracker sheet would be $B$5:$MS$5
Hope this makes sense! Thanks
I am trying to create a formula which will use a product code typed into a
cell in the same sheet, look up this code in a separate file, and give me the
sales figure which is offset from this code.
I.e. (if this helps)
This is the formula I have at the moment just using the other file:
=OFFSET('[Budget Tracker Master Copy 2010.xlsm]Total by Product'!$EJ$5,739,3)
but I want the code which is in EJ5 to come from my current sheet which is
in cell B8.
The range to look up in the Budget Tracker sheet would be $B$5:$MS$5
Hope this makes sense! Thanks