How do I compare 2 separate sets of cells of text, to see if each set of cells are equal

[iColonial]

I am trying to find a match for the City and when a difference occurs for the State. The formula that I was trying to use was =IF(AND(A1=A2,B1<>B2),"City Same","Different State") but there is an error in the formula and my knowledge with formulas is a bit limited


City State Results
Boston MA City Diff / State Same
Brooklyn MA City Diff / State Diff
Boston NY Citty Same / State Diff
Boston MA City Same / State Same
Boston MA City Diff / State Diff
Brooklyn NY

[swhitesell]

Try this instead; =IF(AND(A1=A2,B1<>B2),"City Same, Different State","")

This will return "City Same, Different State" when comparing Boston NY and Boston MA. Otherwise you will see a blank.

[mlcb]

Maybe

Data Range

	A	B	C
1	City	State	Results
2	Boston	MA	City Diff / State Same
3	Brooklyn	MA	City Diff / State Diff
4	Boston	NY	City Same / State Diff
5	Boston	MA	City Same / State Same
6	Boston	MA	City Diff / State Diff
7	Brooklyn	NY

Formula in C2 copied down
=IF(A2=A3,"City Same","City Diff")&" / "&IF(B2=B3,"State Same","State Diff")