Hi,
I have a formula where i want to look up a cell which is date populated and then look up the corresponding tab with that date on it.
We have tabs of data for every day. I just need to know what formula do i use to look up the tab? So in the below the XXXX part needs to actually be '3006'!, is indirect the best way to go?
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks in advance
I have a formula where i want to look up a cell which is date populated and then look up the corresponding tab with that date on it.
We have tabs of data for every day. I just need to know what formula do i use to look up the tab? So in the below the XXXX part needs to actually be '3006'!, is indirect the best way to go?
Date | 30/06/2016 |
Total | |
Wins | =COUNTIF('XXXXC:C,'Main Sheet'!$A$3) |
Losses | =COUNTIF(XXXXC:C,'Main Sheet'!$A$4) |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks in advance