How to use a table index from a formula
 

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

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

1 has the same meaning/effect as TRUE.

narendra Wrote:
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


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=273973

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