Index/match dynamic result column

Hi all,

Is it possible to make the column from which index/match gives a return value dynamic, based on a value in a different cell?

In Vlookup I could use a formula like "=VlookupA3;data!A3:E3;formula!B1+1)" to make the result colum dynamic. If the value in b1 would be 3, vlookup would use the fourth column to give a return value.

In index/match the lookup is based an a column header, so I can't use a +1 to make the return value column dynamic. Instead I will manually have to change the column header each month.

For example: I use cell B1 to input the number of the month, for March I enter "3". Based on the "3" I would like to get a return result from column "G". In April however I would change cell B1 to "4", than I would like to get a return result from column "H"

Hope you understand my question and can help me out (also see attachment)

Thanks both

@Tony Valko: Your method works like a charm. Can you explain how the addition of B1 in the end of the formula make it work? That's the only addition you made to the formula it seems?

Great Tony. I tried it onto my actual spreadsheet and it works. I also understand how it works now, so can use it for feature spreadsheets. My question is solved.

Hi Tony,

Can you do the same but with two way index match? What I mean is can you do two way index match and then designate a column like 4?

Thanks