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