View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A.S. A.S. is offline
external usenet poster
 
Posts: 79
Default 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.