Help needed with Function

Y

Yogi Watcher

Hi,

I need to develop a formula which would set cell value to
TRUE or FALSE depending on if value of some other cell is
in the given set.

For example: A1 is set to TRUE if value in A2 is
contained in range of values from B1:B10. Or A1 is set to
TRUE if value in A2 is contained in array
{1,2,3,4,5,6,7,8,9,10,11,12}

How would I write my cell formula to do this?

Thanks
Yogi Watcher
 
P

Peo Sjoblom

No need for IF at all

=ISNUMBER(MATCH(A2,B1:B10,0))

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top