Help with creating a matching formula?

[JMITCH26]

How can I Look in cells A1:F1 to see if there is a match in cells A12: A17.
If there is a match say "YES" if not then say "NO" in cell H1
If no data is entered in cells A1:F1 then be blank in H1

Example:

look at Cells
...... A1 B1 C1 D1 E1 F1
1 . 3 2 4 1 4 1

...... A2 B2 C2 D2 E2 F2
2 . 2 3 2 3 5 0

...... A3 B3 C3 D3 E3 F3
3 . 2 3 5 0 5 0

...... A4 B4 C4 D4 E4 F4
4 . 2 3 2 3 2 3

Then compare to Cells A12:A17
A12.. 324141
A13.. 504132
A14.. 232323
A15.. 232323
A16.. 413232
A17.. 414141

if there is a match then say "yes" or "no" in cell H1
H1=Yes
H2=NO
H3=NO
H4=Yes

 

[FDibbins]

Soi you are saying that you have a cell containing 3, another with 2, another with 4 etc
and you want to compare the combined contents o 6 cells with the contents of 1 cell, elsewhere?

 

[JMITCH26]

yes

 

[Peter_SSs]

Here are 2 options to consider. Column I option requires Excel 2016 through Office 365.
I have assumed A12:A17 contains numbers, not text. If text, leave out the "+0"

Book1
	A	B	C	D	E	F	G	H	I
1	3	2	4	1	4	1		Yes	Yes
2	2	3	2	2	5	0		No	No
3	2	3	5	0	5	0		No	No
4	2	3	2	3	2	3		Yes	Yes
5
11
12	324141
13	504132
14	232323
15	232323
16	413232
17	414141
Match anywhere

Cell Formulas
Range	Formula
H1	=IF(ISNUMBER(MATCH((A1&B1&C1&D1&E1&F1)+0,A$12:A$17,0)),"Yes","No")
I1	=IF(ISNUMBER(MATCH(CONCAT(A1:F1)+0,A$12:A$17,0)),"Yes","No")

 

[JMITCH26]

Thank you that works perfectly!

 

[Peter_SSs]

Thank you that works perfectly!

You are welcome. Glad it helped.