Formula help = vlookup

J

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
 
D

Don Guillett

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