Match numbers in list

[richard3009]

I'm trying to create a spreadsheet that will check 8 selected numbers against the full UK lottery draw history, I want the spreadsheet to show hits of 3 matching numbers upwards, if possible would also like to check with and without bonus ball.

If anyone could write it for me. I would be very grateful thank you

[nightcrawler-jay]

Hi ther.

Have you tried =if(