Stevenb2020
New Member
- Joined
- Feb 19, 2019
- Messages
- 3
I have the following Index, match, match in my worksheet:
=-INDEX(Table2018PL[[#Headers],[#Data],[GlCode]:[4thQtr]],MATCH('FULL YEAR'!$A8,Table2018PL[[#Headers],[#Data],[GlCode]],0),MATCH('FULL YEAR'!E$5,Table2018PL[[#Headers],[GlCode]:[4thQtr]],0))
I would like to replace Table2018PL with Table2019PL using data from an input cell in another tab. The reference appears 3 times, once for array and twice for lookup array. Essentially what I want to do is make the "2018" variable based on user input.
Is there a way to do this?
Thanks,
=-INDEX(Table2018PL[[#Headers],[#Data],[GlCode]:[4thQtr]],MATCH('FULL YEAR'!$A8,Table2018PL[[#Headers],[#Data],[GlCode]],0),MATCH('FULL YEAR'!E$5,Table2018PL[[#Headers],[GlCode]:[4thQtr]],0))
I would like to replace Table2018PL with Table2019PL using data from an input cell in another tab. The reference appears 3 times, once for array and twice for lookup array. Essentially what I want to do is make the "2018" variable based on user input.
Is there a way to do this?
Thanks,