Compare 3 columns not in a string if match

[michelles4731]

I need to compare compensation report. Columns I, M, and P all need to match in each row. What is the formula?

D	E	F	G	H	I	J	K	L	M	N	O	P
Company Name					Attainment				Recurring Revenue			Total Production Revenue
AAA Inc					102				102			102
ABC Toys					185				370			370
BC Cheese					1095				1095			1095
Dog Days Inc.					600				1200			1200
Produce to You					250				250			250
Sunkin Ships					375				750			750

<tbody>
</tbody>

 

[Special-K99]

You havent actually specified what you want listed, just that "they need to match".
If you want to list only those companies where columns I M and P all match then use this

in Q1
=IFERROR(INDEX($D$1:$D$6,SMALL(IF((I$1:I$6=M$1:M$6)*(I$1:I$6=P$1:P$6),ROW($A$1:$A$6)),ROW(A1))-(ROW(A$1)-1),1),"")
Array formula, use Ctrl-Shift-Enter
and copy down the column

 

[michelles4731]

Excellent point. I would like the formula to return an empty cell if all cells match and "doesn't match" in the rows that don't match.

 

[Special-K99]

in Q2
=IF(AND(I2=M2,I2=P2),"","Doesn't match")
and copy down the column

 

[michelles4731]

That worked perfectly. Thank you.