Formula for matching numbers

[Kalpesh64]

I have a table with 8 columns and 1000 rows. I would to enter a formula in column M, which will check each rows (A1:H1000) for 2 numbers from J1 and K1. If a row has both of this number it will enter "1" in the cell in column M and if not, it will enter "0".

 

[KRice]

Here is one idea:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	11	1	2	26	3	4	5	6		11	26		1
2	1	11	11	4	26	11	7	8					1
3	1	2	3	4	26	6	11	8					1
4	1	2	26	4	5	6	7	8					0
Sheet2

Cell Formulas
Range	Formula
M1:M4	M1	=--AND(COUNTIF(A1:H1,$J$1),COUNTIF(A1:H1,$K$1))

 

[Kalpesh64]

Here is one idea:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	11	1	2	26	3	4	5	6		11	26		1
2	1	11	11	4	26	11	7	8					1
3	1	2	3	4	26	6	11	8					1
4	1	2	26	4	5	6	7	8					0
Sheet2

Cell Formulas
Range	Formula
M1:M4	M1	=--AND(COUNTIF(A1:H1,$J$1),COUNTIF(A1:H1,$K$1))

Thank you KRice. It's perfect.

 

[KRice]

That's great. I'm happy to help.