Hey @PCesarRT26, I don't know of a great way to dynamically reference a column but I do have a couple suggestions for solutions to your issue.
First, you could use a Switch statement along with the Month function to accomplish your goal. Here is an example:
LookUp(
Table1,
'Part Code'=Subtitle1.Text,
Switch(
Month(Today()),
1, '1',
2, '2',
3, '3',
4, '4',
5, '5',
6, '6',
7, '7',
8, '8',
9, '9',
10, '10',
11, '11',
12, '12'
)
)
That should work for you but I think we might be able to simplify it a bit. Galleries have a great function called ThisItem that allows an easy way to access columns of a data set by the current row the gallery is using. So instead of using a lookup, you could do the following:
Switch(
Month(Today()),
1, ThisItem.'1',
2, ThisItem.'2',
3, ThisItem.'3',
4, ThisItem.'4',
5, ThisItem.'5',
6, ThisItem.'6',
7, ThisItem.'7',
8, ThisItem.'8',
9, ThisItem.'9',
10, ThisItem.'10',
11, ThisItem.'11',
12, ThisItem.'12'
)
This simplifies the statement and lets the gallery do the work. Unless I am misunderstanding what you are doing, this would probably be the better way to go.
Let me know if that solves things or if it doesn't! I'd be happy to follow up if needed!
