Combine 2 rows if name is same in Column B & C on both

[wk]

Combine 2 rows if name is same in Column B & C on both

2 spreadsheets - Sheet 1 is bigger with extra names in column B & C
Lastname Firstname

Both - Column B & C Lastname Firstname - both sheets

Sheet 1 has data in Col. D & E
Sheet 2 has data in Col. F & G

Sheet 1 has extra names not in Sheet 2

If Sheet 1 B&C = Sheet 2 B&C ,
then add F&G columns from sheet 2 ,
behind D& E columns on sheet 1 , for the match of names in Column B &
C

Thanks
(e-mail address removed)

 

[carlo]

Combine 2 rows if name is same in Column B & C on both

2 spreadsheets - Sheet 1 is bigger with extra names in column B & C
Lastname Firstname

Both - Column B & C Lastname Firstname - both sheets

Sheet 1 has data in Col. D & E
Sheet 2 has data in Col. F & G

Sheet 1 has extra names not in Sheet 2

If Sheet 1 B&C = Sheet 2 B&C ,
then add F&G columns from sheet 2 ,
behind D& E columns on sheet 1 , for the match of names in Column B &
C

Thanks
(e-mail address removed)

If it is possible to enter a new column after column B in your sheet 2
then you
could enter following formula to your NEW sheet2!column C:
=A1 & " " & B1
and copy it down.

then in your sheet1!column F you could use this formula:
=vlookup(A1 & " " & B1,sheet2!C:H,5,false)
and in your sheet1!column G:
=vlookup(A1 & " " & B1,sheet2!C:H,6,false)

maybe you need to change the numbers for Col_Index, because
I have no Idea how your sheet is built, but otherwise it should work.

hth
Carlo