ALLOW A REFERENCE IN "TABLE_ARRAY" POSITION OF LOOKUP & INDEX FUN.
 

When using lookup or index functions why can't references or functions
allowed to determine the table_array name? That said is there better work
arounds than nested "IF" statements?

Not sure what you mean, but could a named range help? For example, create a
NAME called Test with a range of A1:B3. Then have a vlookup of something
like =VLOOKUP("Joe",Test,2,FALSE)
HTH,
Gary Brown


"fcjssc" wrote in message
...
When using lookup or index functions why can't references or functions
allowed to determine the table_array name? That said is there better work
arounds than nested "IF" statements?

See one response at your later post
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"fcjssc" wrote in message
...
When using lookup or index functions why can't references or functions
allowed to determine the table_array name? That said is there better work
arounds than nested "IF" statements?