Changing Column Cell References by updating one cell

[theanchorman]

I have a spreadsheet where multiple cells are pulling data from one column using cell references based on the month I need. Currently i use the find and replace option to change the column if need to point to the a different month. Is there a way i can write formulas to where I can point to one cell that has the column stated and if I change the one cell it changes all the cell references to pull from another column?

Ex. Cell B30 is data from February month and currently I use the find and replace function to change the column from B to C if i need the data to pull from a different month March. Is there a way I can link the cell references to one cell and i can change that one cell that says "B" and change to "C" so all formulas would update to pull from column C30?

 

[KRice]

Here is one approach using INDEX and MATCH. Change the value in F1 and the formula in the Mo. Report column matches to the data table at left. There are some other approaches if this one isn't suitable. In particular, a solution using the INDIRECT function may be another option.

MrExcel_2.xlsm
	A	B	C	D	E	F
1					Month -->	Mar
2	Jan	Feb	Mar		Mo. Report
3	1	2	8		8
4	2	3	13		13
5	3	5	21		21
Sheet21

Cell Formulas
Range	Formula
E3:E5	E3	=INDEX($A$3:$C$5,,MATCH($F$1,$A$2:$C$2,0))