Here is my formula

=IF(ISNUMBER(Z11),(IF((VLOOKUP(S11,Results!Q:R,2,0 ))((VLOOKUP(AL11,Results!Q:R,2,0))+1),"W","L"))," ")

The formula works perfect but I want the cell to display "P" if
VLOOKUP(S11,Results!Q:R,2,0))=((VLOOKUP(AL11,Resul ts!Q:R,2,0))+1)

(NOTICE THE EQUAL SIGN INSTEAD OF THE SIGN). If the numbers are equal I
need the cell to display "P" instead of "L". Thanks

=IF(ISNUMBER(Z11),(IF(VLOOKUP(S11,Results!Q:R,2,0) (VLOOKUP(AL11,Results!Q:R
,2,0)+1),"W",IF(VLOOKUP(S11,Results!Q:R,2,0)=(VLOO KUP(AL11,Results!Q:R,2,0)+
1),"P","L"))),"")


--
HTH

Bob Phillips

"Jambruins" wrote in message
...
Here is my formula


=IF(ISNUMBER(Z11),(IF((VLOOKUP(S11,Results!Q:R,2,0 ))((VLOOKUP(AL11,Results!
Q:R,2,0))+1),"W","L")),"")

The formula works perfect but I want the cell to display "P" if
VLOOKUP(S11,Results!Q:R,2,0))=((VLOOKUP(AL11,Resul ts!Q:R,2,0))+1)

(NOTICE THE EQUAL SIGN INSTEAD OF THE SIGN). If the numbers are equal I
need the cell to display "P" instead of "L". Thanks

thanks, works perfectly

"Bob Phillips" wrote:

=IF(ISNUMBER(Z11),(IF(VLOOKUP(S11,Results!Q:R,2,0) (VLOOKUP(AL11,Results!Q:R
,2,0)+1),"W",IF(VLOOKUP(S11,Results!Q:R,2,0)=(VLOO KUP(AL11,Results!Q:R,2,0)+
1),"P","L"))),"")


--
HTH

Bob Phillips

"Jambruins" wrote in message
...
Here is my formula


=IF(ISNUMBER(Z11),(IF((VLOOKUP(S11,Results!Q:R,2,0 ))((VLOOKUP(AL11,Results!
Q:R,2,0))+1),"W","L")),"")

The formula works perfect but I want the cell to display "P" if
VLOOKUP(S11,Results!Q:R,2,0))=((VLOOKUP(AL11,Resul ts!Q:R,2,0))+1)

(NOTICE THE EQUAL SIGN INSTEAD OF THE SIGN). If the numbers are equal I
need the cell to display "P" instead of "L". Thanks