Is it in the list?

[davebonallack]

Hi all. Is there a function that will tell me if the content of one
cell, appears somewhere in a list of other cells?
Example: Sheet has 91 names in cells A10:A100
Operator enters a name in Cell A1. If the entered name appears in the
list in cells A10:A100, then do A. If the name does not appear in the
list in cells A10:A100, then do B.
Thanks.
Dave.

 

[Max]

One way

=IF(A1="","",IF(ISNUMBER(MATCH(A1,A10:A100,0)),"<do A>","<do B>"))

 

[davebonallack]

One way

=IF(A1="","",IF(ISNUMBER(MATCH(A1,A10:A100,0)),"<do A>","<do B>"))
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik





- Show quoted text -

Thanks, works a treat.

 

[Max]

welcome, glad it helped