Indirect function on a Table Column name

[legalhustler]

I have a drop down list in cell A1 with years (2018, 2019, 2020). I want to make a formula dynamic based on cell A1, how do I use INDIRECT function on the column part of a table nomenclature where it says 2019?

FiscalYear[2019 Actual]

 

[RoryA]

INDIRECT("FiscalYear["&A1&" Actual]")

would be the equivalent.

 

[legalhustler]

Also, how would I use INDIRECT around this where it says 2020:

MainOffice2020[Color]

 

[legalhustler]

Thank you! I got my other one to work too.