Here's one for you...(thanks for the help in advance)

J

Jambruins

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,Results!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
 
B

Bob Phillips

=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)=(VLOOKUP(AL11,Results!Q:R,2,0)+
1),"P","L"))),"")
 
J

Jambruins

thanks, works perfectly

Bob Phillips said:
=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)=(VLOOKUP(AL11,Results!Q:R,2,0)+
1),"P","L"))),"")
Click to expand...
 
Top