If range equals another range

[mattress58]

I have two sets of data:
B4:D28 & H4:J28

What I need to do is:
check B4:D4 and if matches exactly any row in H4:J28 than put the letter Y in E4

then check B5:D5 and if matches exactly any row in H4:J28 than put the letter Y in E5

and so on all the way from B4:D4 through B28:D28

[stnkynts]

Try this:

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[shg]

How about a formula? In E2, confirmed with Ctrl+Shift+Enter,

=IF(OR(MMULT(--(B4:D4=$H$4:$J$28),{1;1;1})=3), "Y", "")

Then copy down.

	B	C	D	E	F	G	H	I	J
4	2	4	1	Y			4	5	5
5	5	2	2				2	1	2
6	3	3	1				2	4	1
7	2	3	1				1	5	1
8	1	5	2				3	4	4
9	2	5	5				1	2	1
10	4	2	5	Y			1	3	1
11	4	1	5				5	4	1
12	3	2	3				1	2	3
13	2	5	5				1	3	4
14	2	3	5	Y			4	2	5
15	2	3	4				5	4	2
16	1	5	5				1	3	2
17	1	4	3	Y			4	1	2
18	1	5	5				1	4	3
19	2	5	1				2	5	3
20	4	5	2				4	3	1
21	1	4	2				1	1	3
22	2	3	4				2	1	3
23	5	4	3				1	2	3
24	2	3	2				1	2	5
25	2	1	2	Y			4	5	5
26	5	1	1				5	4	4
27	2	3	2				2	3	5
28	4	4	5				3	1	2

[Izandol]

Perhaps
=IF(COUNTIFS($H$4:$H$28,B5,$I$4:$I$28,C5,$J$4:$J$28,D5)>0,"Y","")

[mattress58]

All 4 answers worked like a champion, I tried them all. Thanks for the help !!!!!!!!!!!!!!!!