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;TRU E) I get an error.
Possibly excel cannot compute xplace(AU8) correctly as a text value .

Pls help

Narendra