Auto Looking up a tab on sheet indexing a certain cell

[ardykav]

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?

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

 

[ardykav]

I have tried this to start

=COUNTIF(INDIRECT(B1&"'!"&C:C),A3)

<tbody>
</tbody>

Any ideas?

 

[CyrusTheVirus]

You were close. Try the below.

=COUNTIF(INDIRECT("'"&B1&"'!C:C"),A3)

 

[ardykav]

Perfect thanks a lot

You were close. Try the below.

=COUNTIF(INDIRECT("'"&B1&"'!C:C"),A3)

 

[CyrusTheVirus]

You're welcome.