Offset formula

[prathap1022]

HelloTeam,

My name is prathap, i need one help in offset formula.

I have made a dropdown list, when i click on month i get month detail in the Column

But i need the data in the right side of the sheet. When i click on the month i should get the month details in row wise.

Need your support in solving the problem.


Drop Down - Aug'18


Apr'18
May'18
Jun'18
Jul'18
Aug'18

 

[prathap1022]

Re: Need help in Offset formula

=IFERROR(OFFSET($B$2:B2,0,0,MATCH($E$1,$B$2:$B$15,1)),"-") offset formula i have entered