Indexing Range Labels

[Hawk Lava]

Does anyone know how to index through a set of range labels?

I have a set of range labels,
{wk1, wk2, wk3, ..... wk52}

I would like to have a formula which addresses each label as in:

VLOOKUP($C1,wk1,2,FALSE)
..
..
..
..
VLOOKUP($C52,wk52,2,FALSE)

Any ideas?

Regards,
Hawk

 

[Hawk Lava]

Anon,

Thanks, that did the trick.

I had tried to use something similar, but I didn't know about the
indirect function.

Appreciated!

Hawk