从带有下拉列表的表中选择数据

I have a very big table where I add a column every month with new prices. Then, I have to perform some analysis with those values. I have already made it but with the name of the column in the formula. I want to know if I can point the formula to the drop-down so I just select the new period when it is available and get the results.I have a very big table where I add a column ev