How to use a table index from a formula

[narendra]

I have a function where I wish to choose my lookup table (I have several
range names defined for each of these tables)
I have written a function which can compute the correct range name but when
I use this in the formula
=VLOOKUP(IF(AE8<0.37;0.37;AE8);(xplace(AU8));4;TRUE) I get an error.
Possibly excel cannot compute xplace(AU8) correctly as a text value .

Pls help

Narendra

 

[Aladin Akyurek]

=VLOOKUP(IF(AE8<0.37;0.37;AE8);INDIRECT(AU8);4;1)

1 has the same meaning/effect as TRUE.

 

[Ragdyer]

Try this:

=VLOOKUP(IF(AE8<0.37;0.37;AE8);INDIRECT(AU8);4;TRUE)