How to create euro millions checker in Microsoft Excel

[DANIEL 602]

Hello friends,

I’m trying to make a euro millions checker in excel, I’ve got it to check the five balls ok but having problems with checking the 2 lucky stars cell g4 = 3 ( lucky star 1 camelots No.) cell h4 = 6 ( lucky star 2 camelots No.) cell g7 = numbers i put on ( lucky star 1) cell h7 = numbers I put on (lucky star 2) cell s7 = total lucky stars ( can only answer 0,1,2) as you can only match the max of 2 balls, so can anyone help with a formula please? Thank you

[GALIENA]

According to your data, I just want to suggest you to use the below formula that might work for you. So for that just Try:

=SUMPRODUCT (1 ISNA (MATCH (G7:H7, G4:H4, 0))).