THAT WORKED!!!!!!!!

THANK YOU SO MUCH!!!!!!!!!!!

AWESOME!!!!!!!



"Scott" wrote:

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