reading blank cell as active - how can I stop it ?

  • Thread starter Thread starter Nu-bEE
  • Start date Start date
N

Nu-bEE

W2k + MSO2K3

lookup - a problem -
I am checking winning lotto numbers against a (losing) selection -, i am
using a lookup table, and also count if function to determine how many wins
are acheived in each row.
The problem is:
1... Still waiting to win Jackpot - well win anything would be nice
2. When the `Drawn Numbers` and User Selection Range/s are left blank,
the lookup table reflects it is a win , I have tried to incude a blank cell
with in table but that does not register as a `nil`

=IF(LEN(E27)>0,IF(ISERROR(VLOOKUP(E27,drawn,2,FALSE)),"nil",VLOOKUP(E27,draw
n,2,FALSE)),"")

Please always reply to the group, - KNOWLEDGE IS FOR SHARING --- sorry for
shouting..
 
You may like this better where the winnning list is on row 5 and yours on
row 6
=IF(F6=0,"",SUMPRODUCT(COUNTIF(B6:F6,$B$5:$F$5)))
 
Back
Top