varible table not

  • Thread starter Thread starter spxer
  • Start date Start date
S

spxer

OK I am giving up on the varible tale array. So I will make 20 tables
Now, how can I direct the VLOOKUP to the correct table without using 2
if()'s
 
You can make use of the INDIRECT function. If your tables are named in
some regular way, (eg table_a, table_b, table_c etc), then you should
be able to compute the table you look at. Presumably there would be
some condition to choose the appropriate table?

Hope this helps.

Pete
 
I've just read the thread you were referring to, and have left a
message there which might also be of relevance to you.

Pete
 
I tried INDIRECT() as suggested by daddylonglegs, but I could not get it
to work. I will try, try again. Thanks
 
You must log in or register to reply here.

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

how to get value from a table satisfying two conditions 2
copy data between sheets, but not the formula 1
using vlookup in vba 10
SendObject acXXXXXX use of varibles 2
Vlookup not consistently grabbing the data requested 1
Multiple IFs prior to Count function 3
Varible scope 2
check boxes, determining checked state 1

Back
Top