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:D$2,G1),"ok","no")


--
Biff
Microsoft Excel MVP


"Maria Teresa" wrote in message
...
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......
--
Teresa