clumzyfish
New Member
- Joined
- Oct 6, 2009
- Messages
- 29
I would like to create a vlookup formula that references a range in another workbook. The name of the workbook will be in a cell on the original workbook and the range will always be "BR".
For example, Workbook1:
A1 contains the data to be looked up
A2 contains the workbook name where I would like to get data from = workbook2.xlsm
A3 = VLOOKUP formula to search for the range "BR" in the workbook in cell A2
For example, Workbook1:
A1 contains the data to be looked up
A2 contains the workbook name where I would like to get data from = workbook2.xlsm
A3 = VLOOKUP formula to search for the range "BR" in the workbook in cell A2