Need help wit formula

[Maria Teresa]

I need a formula that help me find a cell...example I am looking for people
in a worksheet (IN A LARGE RANGE) on a separate colum I have a list of
people that I need to find. EXAMPLE
a b c d
1 Marie Susan Luis Ann
2 Albert Jessi Carmen Linda

1 Ann ok
2 Ross no
3 Jessi ok
Thanks for your suggestions and help......

 

[Eduardo]

Hi Maria,
I assume that you have the names in row 1 and 2 and the list start in A4 in
B4 enter

=IF((COUNTIF($A$1:$D$2,A74)>0,"OK","NO")

 

[Eduardo]

Opps,
change A74 by A4

Hi Maria,
I assume that you have the names in row 1 and 2 and the list start in A4 in
B4 enter

=IF((COUNTIF($A$1:$D$2,A74)>0,"OK","NO")

 

[T. Valko]

Let's assume your list of names to lookup is in the range G1:G3 -

G1 = Ann
G2 = Ross
G3 = Jessi

Enter this formula in H1 and copy down to H3:

=IF(COUNTIF(A$1$2,G1),"ok","no")