Hi,

I have a advanced question that I cannot wrap my head around. Looking at the attached picture you can get a feel for what I am trying to accomplish. Where it says input I want to be able to type a number from 1-12 and have the cells in row 16 (Columns C/D respectively) return a specific cell reference as pertains to the input. For example if I input a 1 I want cell C16 to return a cell reference to the matching month (January). I am sorry if I explained this poorly it is quite difficult to understand what I am trying to do. Any help would be greatly appreciated!

Thanks,
Amitus

Capture.PNG