Needing help with a complicated Ifs/and/search please

[Needs Help1]

I have a field of data which needs to be compared in multiple places, I keep almost getting there but am missing the final bit to make it work, would appreciate any assistance with this!

One table of data has an individually coded number which needs to be searched for in the other table of information.
Once the correct line has been found the 3 other points of data need to be matched. Just need a simple Yes, or No as to whether it matches.

Example.

3, G, H, I
2, A, B, C

1, A, B, C
2, D, E, F
3, G, H, I
4, J, K, L

Will find and confirm that the line in question does match to one of the other lines but the second doesn't.

 

[jtakw]

Hi,

Is each row's data in the same cell, or in 4 separate cells ?

 

[Needs Help1]

S

Hi,

Is each row's data in the same cell, or in 4 separate cells ?

Separate cells

 

[jtakw]

I think just COUNTIFS would do:

Book3.xlsx
	A	B	C	D	E
1	3	G	H	I	Yes
2	2	A	B	C	No
3
4
5
6	1	A	B	C
7	2	D	E	F
8	3	G	H	I
9	4	J	K	L
Sheet1065

Cell Formulas
Range	Formula
E1:E2	E1	=IF(COUNTIFS(A$6:A$9,A1,B$6:B$9,B1,C$6:C$9,C1,D$6:D$9,D1),"Yes","No")

 

[Needs Help1]

I think just COUNTIFS would do:

Thanks so much for the help, I was way over complicating that! It works perfectly, much appreciated

 

[jtakw]

You're welcome, thanks for the feedback.