Code:
I have a spreadsheet with the following tabs: Lotto Numbers, Drawn, Historic.
The lotto numbers tab i have in column A: peoples names, then column B i have number 1 (number they have picked) column C number 2 they have picked and column D number 3.
These will remain fixed and not change.
In Drawn tab i have Column A: date then Column B:G Number 1-6.
this shows the numbers that have been drawn.
The Historic tab i have Column A:Peoples names Column B:C the first date on the Drawn tab, cells b2 i have "3 numbers" c2 i have "2 numbers".
Below i have a simple Yes or No formula to work out if the numbers have been drawn, but what i cant do is make it look up the date in cell B1:C1 that is merged to look at the drawn tab.
The formula i have is: =IF(COUNTIF(Drawn!$B$2:$G$2,'Lotto Numbers'!$B3)+COUNTIF(Drawn!$B$2:$G$2,'Lotto Numbers'!$C3)+COUNTIF(Drawn!$B$2:$G$2,'Lotto Numbers'!$D3)=3,"Yes","No")
How can i make it pick up week on week when i add the numbers drawn on the drawn tab?
Here is the file: http://www.filedropper.com/irishlotto
thanks
