is there any way to populate multiple data from different workbooks at once
using any function? EX:
workbook 1
col1 col2
a 1
b 2
c 3
d 4
e 5
f 6
g 7
a 1
c 3
d 4

Workbook 2
Col1 Col2
a aa
b bb
c cc
d dd
e ee
f ff
g gg
a aa
c cc
d dd

In workbook 3 im trying to populate data from both wkbk 1 and 2 using the
col 1 as reference.

Workbook 3

COL1 COL 2 COL 3
a 1 aa
b 2 bb
c
d
e
f
g
a
c
d

I wanna populate col 2 and 3 at once instead of having to do 2 vlookups.

Any help wld be appreciated

Hi Nick
See this article. You may have to join to view but it costs nothing and is
informative.
http://techrepublic.com.com/5100-10877_11-5710152.html

HTH

"nick" wrote:

is there any way to populate multiple data from different workbooks at once
using any function? EX:
workbook 1
col1 col2
a 1
b 2
c 3
d 4
e 5
f 6
g 7
a 1
c 3
d 4

Workbook 2
Col1 Col2
a aa
b bb
c cc
d dd
e ee
f ff
g gg
a aa
c cc
d dd

In workbook 3 im trying to populate data from both wkbk 1 and 2 using the
col 1 as reference.

Workbook 3

COL1 COL 2 COL 3
a 1 aa
b 2 bb
c
d
e
f
g
a
c
d

I wanna populate col 2 and 3 at once instead of having to do 2 vlookups.

Any help wld be appreciated