Populate cells when Month is chosen in combobox for a specific name

Hi all,

I wondered whether someone can point me in the right direction with this. I have a combobox that has a list of months, when a month is chosen in the combobox I require a formula to populate the values in each column for a specific name and the month chosen from a data sheet.

I believe INDEX & MATCH will be able to do this however I cannot figure out how to link it with the combobox or how to populate all columns.

Can anyone at least give me some pointers on this? A sample has been provided.


Thanks guys!