Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"James" wrote in message
...
I would like to have a list defining different weeks. This is the easy
part.
But i want that list to change values in different formules.

So if i select week 2, then all formulas for examplethe formulae
=vlookup(b7;sheet1 week1,2,0) will automatically change to week 2 without
having to go and change all the formuales or using find and replace.

Thanks