Indexing Range Labels

  • Thread starter Thread starter Hawk Lava
  • Start date Start date
H

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
 
Anon,

Thanks, that did the trick.

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

Appreciated!

Hawk
 
Back
Top