Is it in the list?

  • Thread starter Thread starter davebonallack
  • Start date Start date
D

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.
 
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 -
Click to expand...

Thanks, works a treat.
 
Back
Top