Vlookups across workbooks [Solved/Closed]

Report
-
 Nocular -
Hello,
I'm wanting to perform VLookups across seperate workbooks, as I have a reference workbook where all updates are added and then a number of summary workbooks that I need to extract the data from the erference workbook to. The reference workbook is set so data locations will not change, In the summary workbooks I want to select the name and then the relevant data from the reference workbook comes across.

Cheers


2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
I suppose it is possible. for writing the formula easily keep all workbooks open. then instead of writing the arguments use cursor to go to the different ranges except for 3rd argument (column number) and fourth argument will be zerio

an example


=VLOOKUP(A28,'[infoline stocks oct10.xls]current'!$A$1:$F$15,3,0)
Brilliant, works I htink where I was going wrong was that I was referencing to the reference data sheet twice ie once for table array and teh other for the required column. Take out one of teh references to that workbook and hey presto..

Thanks