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" <fcjssc@discussions.microsoft.com> wrote in message
news:B6A3E73B-9735-4AA7-BF5C-61F7D1E340D2@microsoft.com...
> 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 <at>yahoo<dot>com
----
"fcjssc" <fcjssc@discussions.microsoft.com> wrote in message
news:B6A3E73B-9735-4AA7-BF5C-61F7D1E340D2@microsoft.com...
> 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?