Embedding functions in Vlookup?

[Guest]

On one tab called CheckSheet I have the following:
Check Range
123 XYZ
456 CDR

On another tab I have ranges named XYZ and CDR. I need to be able to create
a vlookup inside a vlookup. Here is what I am thinking should work but
doesn't:

+vlookup(z1,+vlookup(a1,'CheckSheet'!A1:B3,2),2)

Basically I need a vlookup to use the "range" name that resulted from
another vlookup. I am sure there is something simple I am missing but it is
driving me crazy. Any help is greatly appreciated. The above results in
#value.

 

[Guest]

try:

=VLOOKUP(Z1,INDIRECT(VLOOKUP(A1,'CheckSheet'!A2:B3,2,FALSE)),2,FALSE))

 

[Domenic]

Try...

=VLOOKUP(Z1,INDIRECT(VLOOKUP(A1,'CheckSheet'!A1:B3,2)),2)

Hope this helps!