# I am trying to make a lottery checker in excel,but dont know which formula to use to make it work.

My draw numbers are in cells a1 to f1

i can make the programs tell me how many numbers i have but i also want it to print plus bonus ball this draw number will be in i1

the checker needs to check balls in a1 to f1 then if the number is present print the word plus bonus ball in anothe cell

any help much appreciated

Hello there

Could you perhaps email the spreadsheet so I could have a look what you have so far so I can have a clear understanding? info@excelgeek.co.uk

Thanks