try If you want to enter the name in Cell C1 and have D1 give the result
in D1 enter a
=if(Vlookup(C1,$A$1:$B$99,2,false)="X","OK","nope"
and in C1 enter the name
"Scott" wrote:

> 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