|
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 |
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 |
| All times are GMT +1. The time now is 09:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com