LOOKUP OR INDEX/MATCH TO FIND NUMBER?
 

I was looking for a formula that looks up a number in a large table.
Basically if it finds that number in that table then "YES", otherwise "NO".
This some Example data, but the table is much larger. Also, note, that the
only number that can be found more than once is 0, which is not searched
anyways so we don't care about 0.

I14=1
I15=2
I16=22
I17=34
I18=41

2 1 3 0 0 0
4 6 7 5 0 0
8 9 14 12 11 13
20 21 18 19 17 16
28 27 32 26 23 25
36 41 35 38 33 37

J14=YES
J15=YES
J16=NO
J17=NO
J18=YES

Any help would be appreciated.

LOOKUP OR INDEX/MATCH TO FIND NUMBER?
 

How About
=if(countif(Table Range,I14)0,"Yes","No")

"A.S." wrote:

I was looking for a formula that looks up a number in a large table.
Basically if it finds that number in that table then "YES", otherwise "NO".
This some Example data, but the table is much larger. Also, note, that the
only number that can be found more than once is 0, which is not searched
anyways so we don't care about 0.

I14=1
I15=2
I16=22
I17=34
I18=41

2 1 3 0 0 0
4 6 7 5 0 0
8 9 14 12 11 13
20 21 18 19 17 16
28 27 32 26 23 25
36 41 35 38 33 37

J14=YES
J15=YES
J16=NO
J17=NO
J18=YES

Any help would be appreciated.

LOOKUP OR INDEX/MATCH TO FIND NUMBER?
 

I think this works, I just took out the 0, because all are greater than
zero. Zero is not a possible search option, even though it might exist in the
data table. Thanks Sean.

"Sean Timmons" wrote:

How About
=if(countif(Table Range,I14)0,"Yes","No")

"A.S." wrote:

I was looking for a formula that looks up a number in a large table.
Basically if it finds that number in that table then "YES", otherwise "NO".
This some Example data, but the table is much larger. Also, note, that the
only number that can be found more than once is 0, which is not searched
anyways so we don't care about 0.

I14=1
I15=2
I16=22
I17=34
I18=41

2 1 3 0 0 0
4 6 7 5 0 0
8 9 14 12 11 13
20 21 18 19 17 16
28 27 32 26 23 25
36 41 35 38 33 37

J14=YES
J15=YES
J16=NO
J17=NO
J18=YES

Any help would be appreciated.

LOOKUP OR INDEX/MATCH TO FIND NUMBER?
 

Thank you for the feedback! Glad to know it worked!

"A.S." wrote:

I think this works, I just took out the 0, because all are greater than
zero. Zero is not a possible search option, even though it might exist in the
data table. Thanks Sean.

"Sean Timmons" wrote:

How About
=if(countif(Table Range,I14)0,"Yes","No")

"A.S." wrote:

I was looking for a formula that looks up a number in a large table.
Basically if it finds that number in that table then "YES", otherwise "NO".
This some Example data, but the table is much larger. Also, note, that the
only number that can be found more than once is 0, which is not searched
anyways so we don't care about 0.

I14=1
I15=2
I16=22
I17=34
I18=41

2 1 3 0 0 0
4 6 7 5 0 0
8 9 14 12 11 13
20 21 18 19 17 16
28 27 32 26 23 25
36 41 35 38 33 37

J14=YES
J15=YES
J16=NO
J17=NO
J18=YES

Any help would be appreciated.