Lookup Functions
 

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

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

Any help wld be appreciated

You have a previous thread with a response
See Help for Consolidate Date on multiple worksheets


"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

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

Any help wld be appreciated

Hi,

You can also use the vlookup function (Please see the Excel Help menu)

Regards,

Ashish Mathur

"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

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

Any help wld be appreciated

Hi ashish, i been using Vlookup but it cant populate 3 colums at the same
time tho. i want to use one function which is gonna populate col 1, 2 and 3
data from workbook1 in to col 2, 3 and 4 of workbook 2. i dont want to use
the function 3 times for 3 different columns. i hope i made myself clear.

And ray, the link that suggested is not something that im trying to
do...thanks a lot tho.

"Ashish Mathur" wrote:

Hi,

You can also use the vlookup function (Please see the Excel Help menu)

Regards,

Ashish Mathur

"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

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

Any help wld be appreciated