Is it in the list?
 

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.

Is it in the list?
 

One way

=IF(A1="","",IF(ISNUMBER(MATCH(A1,A10:A100,0)),"<d o A","<do B"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ps.com...
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.

Is it in the list?
 

On Jun 19, 8:21 am, "Max" wrote:
One way

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

ps.com...



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.- Hide quoted text -

- Show quoted text -

Thanks, works a treat.

Is it in the list?
 

welcome, glad it helped
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote
Thanks, works a treat.