Try this:
=VLOOKUP(IF(AE8<0.37;0.37;AE8);INDIRECT(AU8);4;TRU E)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"narendra" wrote in message
...
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
|