Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |