I have a spreadsheet that looks like this with 1-12 representing the months of the year:
| Company | Account | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| X | 100 | 50 | 651 | | 8499 | 6 | 8 | 86 | | | | 5 | 54 |
| Y | 200 | 12 | 681 | 3254 | | 55611 | | | 8 | 7 | 45 | | |
| Z | 900 | 2513 | 851 | | 4 | | 3585 | | | | 400 | | 78568 |
When the process is run, a user selects a drop down based on what month they want to run the data for. If the user selects July in the drop down box (display says JULY but value is 7) i want the IF statement to pull the value from the drop down box (7) and use it as the column name [7] and pull that value. Example:
If Account = "100" Then [7] endif
The goal is that the drop down selection is used to determine which column is pulled into the formula. I've tried concatenating the field like this ([Month] being the drop down input):
IF Account = "100" THEN "[" + [Month] + "]"
This just gives me the VALUE [7] instead of pulling the value for that field. I would like it to pull the number 86 which is the value for field [7]
