index and match based on one input

[jsalotra]

Hi,

I need to create a formula so that by inputting value of month, values are updated.
I have series of account numbers and based on month, I need to upload values in a different system based on month. For example, In attached sheet, I update value in Colum AA2 and data in column AB and Column AC should be from table B to Y. For July, input of 7 is done in Column AA, and I changed the reference in column AB to N and column AC to O so that July data is updated.

Please help,

Thanks!

[Special-K]

in AB5
=INDEX(B5:Y5,1,MATCH(AA$2,B$4:Y$4,0))
in AC5
=INDEX(B5:Y5,1,MATCH(AA$2,B$4:Y$4,0)+1)

[jsalotra]

Thanks a lot!