| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable table array name in VLOOKUP
I need to retrieve values from an external spreadsheet table, but this table
is variable (one of many). Can anyone help with specifying a variable table array name?? Example : field1 = 1 dbname = vlookup(field1;internal_table;fieldindex) --result = "DataArea2" (or DataArea3 etc) I need to access DataArea2 (or DataArea3 etc) in C:\WORK\external.xls, which is an external spreadsheet... field2 = "something" my_problem=vlookup(field2;'C:\WORK\external.xls'!& dbname;otherfieldindex) How can I stuff the contents of variable dbname in the VLOOKUP syntax?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| array table and vlookup | Excel Worksheet Functions | |||
| VLOOKUP variable array references | Excel Discussion (Misc queries) | |||
| Variable Table Array in Lookup Function | Excel Worksheet Functions | |||
| VLOOKUP - 3 Table Array | Excel Worksheet Functions | |||
| are variable table-array names in functions possible? | Excel Discussion (Misc queries) | |||
Threaded Mode
