Previous Topic Next Topic

Vlookups across workbooks

Solved/Closed
Nocular - Oct 21, 2010 at 08:35 PM
 Nocular - Oct 22, 2010 at 01:44 AM
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 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 22, 2010 at 01:02 AM
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)
0
Answer 2 / 2
Nocular
Oct 22, 2010 at 01:44 AM
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
0

Similar discussions

Copy formulas across workbook
AKK -
1234551 -

9 responses
enabling macros on shared workbooks
SARC -
Petros -

4 responses
Lookup across whole workbook (muliple sheets)
mad -
Mark -

6 responses
Generate excel workbooks based on excel list
m_albges -
rivera -

23 responses
Macro to copy data to new workbooks based on condition
hosinsul -
ac3mark -

1 response