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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

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,894
Messages
5,411,070
Members
403,340
Latest member
fred23

This Week's Hot Topics

Top