| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find by row number | Excel Discussion (Misc queries) | |||
| Find the missing number? | Excel Discussion (Misc queries) | |||
| Data Lookup using find and filtered dropdowns | Excel Discussion (Misc queries) | |||
| Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Hybrid Mode
