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

F

fcjssc

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?
 
G

Gary Brown

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allow refence in the "table_array" position of Lookup functions 1
How do I reference a "range" for a specific table_array in VLOOKUP 3
Page numbering with Merged Document and IF statements 1
HLOOKUP Formula Error 1
vlookup with dynamic table_array 3
Lookup functions always return n/a ??? 3
Problem with HLookup. Not sure if it is a bug or not 3
Insert Vlookup into table_array of Vlookup with named range 1

Top