Compare sheet and return last column Closed

Question

Hello, 

I have two sheets with the same column to compare as follows:

Sheet 1
Column A: First name
Column B: Surname
Column C: Father's name

Sheet 2 
Column A: First name
Column B: Surname
Column C: Mother's name

I need to put the Father's and Mother's name next to each other based on the condition Column A and B are identical in both sheets (i.e. the same First name and Surname).

Thanks for your help in advanced.


Configuration: Windows XP / Internet Explorer 8.0

venkat1926 · Answer

sheet1 is like this

 First name	 Surname	 Father's name 
a	q	t
s	w	y
d	e	u
f	r	i
in D1 type "mother's name" (without quotes)

sheet 2 is like this 
 First name	 Surname	 Mother's name 
a	q	z
s	w	x
d	e	c
f	r	v

in sheet 1 in D2 copy this formula
=INDEX(Sheet2!$C$2:$C$100,MATCH(1,((Sheet2!$A$2:$A$100=Sheet1!A2)*(Sheet2!$B$2:$B$100=Sheet1!B2)),0))
INVOKE THIS FORMULA BY CONTROL SHIFT ENTER
copy D2 down

this will be ok for about 100 rows of data.

Compare sheet and return last column

1 response

Similar discussions

Subscribe To Our Newsletter!