Set membership?

[CentaurSaratoga]

Hi Friends,I have a horizontal list of 5 cells ,each with 1-4 selected no.s in them(I.D) & a
vertical list with All I.D no.s . What function should I use to determine if any of the vertical no.s are members of the horizontal set(s) Answer should be True/False ?
Much Thanks...Retired Amateur.

 

[obiron]

I would try the MATCH() function.

Obiron

 

[shadow12345]

Match Function .... with a IF to get true/false

(If i understand your question)

 

[CentaurSaratoga]

Thanx for your replies,i thought that match w/if may be the answer i am just not entering it properly.

 

[shadow12345]

the correct format for match is

Match(what you to find , where you want to look , 0)
*the 0 means exact match only

 

[CentaurSaratoga]

Greatly appreciate All replys..found this answer on Mr.Xcl and seems to work well...=IF(OR(cell=array),"Yes","No") Ctrl-Shft-entr