I am looking for a formula or way to do the following in Excel:
I have a value, and I want to see if it is contained in an array. I just want a 1 or 0 if it is in the array or not. I could use any of the LOOKUP functions, but they return error messages when the value is not found.
Example:
Array:
101
102
103
104
105
For the value 101, I would like a "1", because it is contained in the array. For the value 108, I would like a 0 (or anythng else I can flag) because it is not contained in the array...
Any ideas?
2006-07-12
03:46:28
·
6 answers
·
asked by
Q&A_Boy
2
in
Software