Compare and combine two columns

[sailingnut]

How do I compare and combine two columns? Column A has a list of business email addresses. Column B has a list of personal email addresses. I want to compare column A and B and put in column C the value from column A if they match. If they do not match, put into column C what is contained in column A. Also, put into column C the contents from column B if a cell in column A is blank.

 

[sandy666]

maybe easier will be to append these columns into one and then remove duplicates

 

[Peter_SSs]

Welcome to the MrExcel board!

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. Hence my simplified samples.

Is this what you mean?

20 10 29.xlsm
	A	B	C
1	Business	Residence	List
2	a	a	a
3	b	z	b
4	c		c
5	d	y	d
6	e	e	e
7		s	s
8		q	q
9	h	h	h
10	i		i
11	j	x	j
Combine lists

Cell Formulas
Range	Formula
C2:C11	C2	=IF(A2="",B2,A2)

 

[sailingnut]

Name	Business email	Personal email	Results
Jana Willis	jwillis@tac.edu	jwillis@tac.edu	jwillis@tac.edu
Max Willis	maxwillis@wcu.edu	maxwillis@gmail.com	maxwillis@wcu.edu
Gabe Willis		gwillis@gmail.com	gwillis@gmail.com
Sam Willis	samwillis@grove.edu		samwillis@grove.edu

Peter. I should have give a better picture of what I'm trying to do.
List example is above.
In the case of Jana, it compared and since they were the same, it brought in Business email to the Results
In the case of Max, it compared and because they were different, it brought in Business email to the Results
In the case of Gabe, Business email was blank, so it brought in Personal email to the Results
Int the case of Sam, Personal email was blank, so it brought in Business email to the Results.
So the Results field would contain some formula to accommodate those scenarios.

 

[McGuilliam]

You could try a formula like this:

=if(E2=F2;E1;if(E2<>"";E2;F2))

 

[Peter_SSs]

I should have give a better picture of what I'm trying to do.
List example is above.
In the case of Jana, it compared and since they were the same, it brought in Business email to the Results
In the case of Max, it compared and because they were different, it brought in Business email to the Results
In the case of Gabe, Business email was blank, so it brought in Personal email to the Results
Int the case of Sam, Personal email was blank, so it brought in Business email to the Results.
So the Results field would contain some formula to accommodate those scenarios.

That is exactly what my formula already did (except the emails are now in columns B & C not A & B as you first stated). Here it is again with your sample data & layout.

20 10 29.xlsm
	A	B	C	D	E	F
1	Name	Business email	Personal email	Formula Results	Your results from post 4	Compare
2	Jana Willis	jwillis@tac.edu	jwillis@tac.edu	jwillis@tac.edu	jwillis@tac.edu	TRUE
3	Max Willis	maxwillis@wcu.edu	maxwillis@gmail.com	maxwillis@wcu.edu	maxwillis@wcu.edu	TRUE
4	Gabe Willis		gwillis@gmail.com	gwillis@gmail.com	gwillis@gmail.com	TRUE
5	Sam Willis	samwillis@grove.edu		samwillis@grove.edu	samwillis@grove.edu	TRUE
Combine lists (2)

Cell Formulas
Range	Formula
D2:D5	D2	=IF(B2="",C2,B2)
F2:F5	F2	=D2=E2