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

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..
 
D

Don Guillett

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)))
 

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

How to get a blank cell instead of a "0" 2
How can I show all field data in a pivot table, instead of blank 3
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY 3
How can I select the first blank cell 4
can lookup return cell reference istead of "text" for sumif? 1
can lookup return cell reference istead of "text" for sumif? 4
How can I summarize what is in more cells in a single one 6
Getting a cell address from Vlookup function in a macro? 3

Top