| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup refering to a cell to get wookbook name
Hi, using Excel 2003. Is it possible to have a vlookup have the name of a
workbook containing the range to lookup (2nd argument) in another cell? Something like the following... =vlookup(a4,"[" & c1 & .xls]Sheet1!$B$11:$D$200,3,FALSE) c1 contains a workbook name. Any ideas or suggestions appreciated :-) -- Many thanks Jonathan Parminter |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup refering to a cell to get wookbook name
You can use
=VLOOKUP(A4,INDIRECT("'[" & C1 & ".xls]Sheet1'!$B$11:$D$200"),3,FALSE) but the other workbook must be open. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jonathan" wrote in message ... Hi, using Excel 2003. Is it possible to have a vlookup have the name of a workbook containing the range to lookup (2nd argument) in another cell? Something like the following... =vlookup(a4,"[" & c1 & .xls]Sheet1!$B$11:$D$200,3,FALSE) c1 contains a workbook name. Any ideas or suggestions appreciated :-) -- Many thanks Jonathan Parminter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REFERING TO CELL IN DIFFERENT SHEET | Excel Discussion (Misc queries) | |||
| Refering a cell | Excel Worksheet Functions | |||
| Refering to an empty cell | Excel Discussion (Misc queries) | |||
| Refering to a tab using data from a cell | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Linear Mode
