Referencing tabs Driven by data

[danman5005]

I want to reference a specific tab, but allow the data to drive the formula. I.e. If the number shows up in my the data then go to 15yr conditions. If the number is 30 then go to 30yr conditions. When writing out the formula the results come back as a text and don't reference the data.

Current formula:
="='"&LEFT(B3,2)&"yr Current Conditions'!H9"
Cell Result:
='15yr Conditions'!H9

 

[par60056]

try:
=indirect(LEFT(B3,2)&"yr Current Conditions'!H9")