Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a cell reference is Vloopup to access external workbooks
Hi, I don't know if this is possible without a vb script, but I'm trying to
use Vlookup to get data from an external workbook. However, the workbook name is variable; e.g. cell A1 contains a workbook name (say User List) that exists in folder c:/Data and the data range in that file is A1 to D22 column D, so the vlookup expression would be =VLOOKUP(A1,C:\Data\[User List.xls]Sheet1'!$A$1:$D$22,4,FALSE). However, if the workbook name changes in cell A1, how can I make the formula pick up the data from the new workbook? Many thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference to cell with external spreadsheet | Excel Worksheet Functions | |||
Reference external worksheet whose name is in a cell | Excel Worksheet Functions | |||
External Cell Reference in VBA? | Excel Programming | |||
dynamic external cell reference | Excel Worksheet Functions | |||
Using Cell Contents to Reference External Workbooks | Excel Programming |