Need help wit formula
 

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

Need help wit formula
 

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")

"Maria Teresa" wrote:

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

Need help wit formula
 

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

Need help wit formula
 

Opps,
change A74 by A4

"Eduardo" wrote:

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")

"Maria Teresa" wrote:

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