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?

[TABLE="width: 507"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Date [/TD]
[TD="align: right"]30/06/2016[/TD]
[/TR]
[TR]
[TD]Total [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Wins[/TD]
[TD] =COUNTIF('XXXXC:C,'Main Sheet'!$A$3)[/TD]
[/TR]
[TR]
[TD]Losses[/TD]
[TD] =COUNTIF(XXXXC:C,'Main Sheet'!$A$4)[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance

 

[ardykav]

I have tried this to start

[TABLE="width: 299"]
<tbody>[TR]
[TD="class: xl65, width: 299"] =COUNTIF(INDIRECT(B1&"'!"&C:C),A3)[/TD]
[/TR]
</tbody>[/TABLE]


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.