Hi all

I have a number of named ranges defined.

I would like to perform a VLOOKUP on the named range as defined in cell A1.

For example, I have defined ranges tableOne and tableTwo

When cell A1 contains the text "tableOne" the lookup should be performed on the named range tableOne. Similarly for tableTwo.

I tried using A1.value to no avail - see below.

=VLOOKUP("some value",A1.value,2,TRUE)

Any help with this is much appreciated.