| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
varible table not
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 20 if()'s? -- spxer ------------------------------------------------------------------------ spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025 View this thread: http://www.excelforum.com/showthread...hreadid=568347 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
varible table not
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 spxer wrote: 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 20 if()'s? -- spxer ------------------------------------------------------------------------ spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025 View this thread: http://www.excelforum.com/showthread...hreadid=568347 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
varible table not
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 Pete_UK wrote: 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 spxer wrote: 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 20 if()'s? -- spxer ------------------------------------------------------------------------ spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025 View this thread: http://www.excelforum.com/showthread...hreadid=568347 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
varible table not
I tried INDIRECT() as suggested by daddylonglegs, but I could not get it to work. I will try, try again. Thanks -- spxer ------------------------------------------------------------------------ spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025 View this thread: http://www.excelforum.com/showthread...hreadid=568347 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| varible table | Excel Worksheet Functions | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| How to import a table on a Web page to Excel? | Excel Discussion (Misc queries) | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
Hybrid Mode
