Formula help = vlookup

[James]

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

 

[Niek Otten]

Look in HELP for the INDIRECT() function

 

[Don Guillett]

Maybe use a macro using find/replace or indirect
=VLOOKUP(D1,INDIRECT("week"&C1),2,2)