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