Formula help = vlookup
 

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

Formula help = vlookup
 

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

Formula help = vlookup
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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