Excel lookups - include a cells value as range name?

[FletchUK]

Hi all,

I'm trying to create a lookup and I want the name of lookup range to be dependant upon the value entered into a cell.

For example, if the user enters the name "Robert" in cell A1 I want the lookup to check the range I've named Robert. If there was only one name the obvious lookup is =vlookup(A6,Robert, 2, false) but with several options I don't know how to make the range a variable. I've tried swapping the word Robert for A1 but this doesn't work. There's probably an easy answer but I don't know it...can anyone help.

Thanks,
FletchUK

 

[SkipVought]

Hi,
[tt]
=vlookup(A6,indirect(a1), 2, false)
[/tt]


Skip,
[sub]
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large! [/sub]

 

[FletchUK]

Brilliant! Thank you very much Skip.

Fletch