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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wk - 13 Nov 2007 03:50 GMT

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
kerns.walter@epa.gov

Reply to this Message

carlo - 13 Nov 2007 04:25 GMT

> Combine 2 rows if name is same in Column B & C on both
>
[quoted text clipped - 15 lines]
> Thanks
> kerns.wal...@epa.gov

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

Reply to this Message

Rate this thread: