VLOOKUP within various named ranges

[johnnyhall81]

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.

[VBA Noob]

Maybe

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

VBA Noob

[johnnyhall81]

Thank you so much. Problem solved.