How To Use A Cell Value As Part of A Sheetname?

[aedctalk]

Maybe i'm overthinking this but here is what i'm trying to do.


Have dropdown of times 12pm to 10pm in square K35 (did that already)

In L35 i did =CONCATENATE("PC",K35)

This gives me my sheetnames.. All are PC12PM - PC10PM

It show correctly in L35

Ok. now down below same sheet i have a "Top 25"

I want it to update automatically with new data if new times are selected in K35


So i tried =IF(ISERR(L35!AD149),,L35!AD149) which i want excel to recognize as timechosen!AD149

doesnt work at all. i guess its not using the text displayed value of what i have in L35 which is showing "PC12PM" is there any way to do this? make it recognize the text value?

or another method of updating the sheet name based on cell value?

Thanks so much!!!

 

[starl]

You need INDIRECT

=INDIRECT(L35&"!AD149")

 

[aedctalk]

Thanks so much! Added in isserror

=IF(ISERR(INDIRECT(L35&"!AD149")),,INDIRECT(L35&"!AD149"))

Works like a charm! Really appreciate the help

You need INDIRECT

=INDIRECT(L35&"!AD149")

 

[starl]

You are very welcome