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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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"))),"")
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF FUNCTION...SHADE CELL 1
VBA coding a nested Vlookup, and a sumif formula 1
vba sumif and vlookup codes 1
VBA coding a nested Vlookup, and a sumif formula 5
Vlookup nesting in VBA code 6
Error in if condition 1
Please can you help. I can not remember what the special formula step is. 3
VLOOKUP question utilizing the right and left of a given column ineed the mid too dont know how to i 1

Back
Top