I am running a UK Health Lottery and have used Excel to show the resullts each week, IE I have 18 columns of a wheel ststem and below it I enter the results each week. Upon entering the results all correct numbers are registered in red Cells in the wheel. My query is. As the prizes are £50 for 3 correct,£500 for 4 correct and then of course the Jackpot, how can I automatically check those lines that are winning ones and place the correct amount of winnings on the sheet? Looking over this it appears to be too complicaated but I am sure there is an expert out there who will put me right. I hope!
Regards...hastinga
PS Please hurry as I'm 86 years old and would like to know before the dreaded Reaper appears