=IF(ISNUMBER(MATCH("John Doe",A1:A99,0)),IF(INDEX(B1:B99,MATCH("John
Doe",A1:A99,0))="X","Match","No match"))

--
HTH

Bob Phillips

"Scott" <Scott@discussions.microsoft.com> wrote in message
news:6722916F-072B-4F09-BB45-6292F4C6E9BE@microsoft.com...
> 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
> >
> >
> >