Hi,
Thanks it works perfect.
Jerry


"PeterAtherton" wrote in message
...
Jerry

Rag has answered you question but if theLaddress of the name is helpful
you
can use:
=IF(ISERROR(MATCH(B2,A1:A200,0)),"No
Match",address(match(b2,a1:a200,0),1))

Regards
Peter
"Jerry Kinder" wrote:

Hi,
Excel 2000 question
I have a Workbook with two sheets "Daily" and "Clients".

In Daily sheet col F
I want a formul in F2 that will look in col B2 and tell me if the
name
in B2 is in Col A2:A200 of sheet the Clients sheet.
Example: this only gives me No. and the name in B2 is in Col A of the
Clients sheet.
IF(B2='Clients'!A1:A200,"Yes","No")

Thanks,
JK