=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" wrote in message
...
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" wrote in message
...
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