J
JC
I have the following formula in a workbook:
VLOOKUP(A6,'[Jun01 Forecast.xls]Salesman Forecast'!
$A$8:$Z$125,26,0)
I have to copy this across multiple pages in a workbook
and change the location of the data each time, ie. from
Jun01 to Jul01 and so on. Using data already in the sheet
I can create a cell , C6, that has the value "Jun01
Forecast.xls" in it. Is there anyway to use this in the
Vlookup function, ie.
VLOOKUP(A6,'[C6]Salesman Forecast'!$A$8:$Z$125,26,0)
however, this syntax doesn't work.
Is there a way to correctly write this so it will work?
Thanks,
JC
VLOOKUP(A6,'[Jun01 Forecast.xls]Salesman Forecast'!
$A$8:$Z$125,26,0)
I have to copy this across multiple pages in a workbook
and change the location of the data each time, ie. from
Jun01 to Jul01 and so on. Using data already in the sheet
I can create a cell , C6, that has the value "Jun01
Forecast.xls" in it. Is there anyway to use this in the
Vlookup function, ie.
VLOOKUP(A6,'[C6]Salesman Forecast'!$A$8:$Z$125,26,0)
however, this syntax doesn't work.
Is there a way to correctly write this so it will work?
Thanks,
JC