Indirect function on a Table Column name

legalhustler

Well-known Member
Joined
Jun 5, 2014
Messages
1,069
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]
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,692
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
INDIRECT("FiscalYear["&A1&" Actual]")

would be the equivalent.
 

legalhustler

Well-known Member
Joined
Jun 5, 2014
Messages
1,069
Also, how would I use INDIRECT around this where it says 2020:

MainOffice2020[Color]
 

Watch MrExcel Video

Forum statistics

Threads
1,089,750
Messages
5,410,215
Members
403,304
Latest member
pajg

This Week's Hot Topics

Top