Bob,

This is SO close... the last bit might prove to be the most difficult part.

That "B1" cell is actually going to be the cell in the same row that the
name is found in column B. My check is IF "John Doe" is found in the range
AND "X" is in the corresponding cell in column B THEN "Match", "No Match".

(fingers crossed you know the answer)

Thanks so much!

Scott



"Bob Phillips" wrote:

> =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
>
> --
> HTH
>
> Bob Phillips
>
> "Scott" <Scott@discussions.microsoft.com> wrote in message
> news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
> > This might be hard to explain...
> >
> > I want to check a sheet for a persons name AND if an X is entered in an
> > associated cell. In literal terms the IF statement would be as follows:
> >
> > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
> THEN
> > "OK")
> >
> > The X would appear in the same row as the name in the range, for example:
> > Field A1 contains "John Doe" and field B1 contains "X".
> >
> > How would I make this work?
> >
> > Thanks,
> >
> > Scott
>
>
>