Extract month number and year

I have text in Col a , months in Col b as well as Month in Col k and the applicable month period in Col L


I have tried to set up a formula in Col c to extract the relevant period number for the month in Col b/the year in the text in Col A


I have shown what the result should look like in Col D. I am trying to extract the period pertaining to a particular month (October being the first month in the financial year, November being the 2nd etc) and to show the period followed by the year for eg 1/2019, 2/2019 etc



I have attached sample data


It would be appreciated if someone could kindly provide me with a formula to do this

Hi Guys


Thanks for the help, much appreciated

Thanks for the help Simmy51