Dynamic Sheet Inserts in Formula

[billymci]

Hope someone can help here.

What I have at the moment is a ComboBox with a ListFillRange that has Monday thru Sunday. There is a linked cell that displays which day is selected in the ComboBox.

So if monday was selected, I'd like the formula to be;
=IF(VLOOKUP(AI27,monday!$A:$A,1,FALSE)=AI27,INDEX(monday!$1:$65536,MATCH(AI27,monday!$A:$A,0),$BB$1))

or if it was tuesday....

=IF(VLOOKUP(AI27,tuesday!$A:$A,1,FALSE)=AI27,INDEX(tuesday!$1:$65536,MATCH(AI27,tuesday!$A:$A,0),$BB$1))
etc

It wouldn't say monday, tuesday etc - it would take the day reference from the cell linked to the ComboBox.

I'll be eternally grateful for a solution.

Many thanks in advance.

[cpod]

If your linked cell is A1 then:

=IF(VLOOKUP(AI27,Indirect(A1 & "!$A:$A"),1,FALSE)=AI27,INDEX(Indirect(A1 & "!$1:$65536"),MATCH(AI27,Indirect(A1 & "!$A:$A"),0),$BB$1))

[billymci]

Cheers mate.

I used VBA code instead, but this looks a little faster.

Thanks again.