Dynamic Index/Match formula based on drop down and check boxes

Hi,

I am struggling with a formula that I believe is actually somewhat simple. I have enclosed a sample workbook for a more detailed explanation.

Basically, I have a combo box that controls which of 5 check boxes that are either shown or hidden, and how the visible boxes are labeled, based on a VBA.

Example.png

I am looking for a formula that - based on the chosen company and the chosen check box (only 1 can be chosen) - can return the name of the chosen group. That is, the formula must recognize which of the 5 check boxes that is chosen, and then combine it with the company name to lookup the group name in a range further down the sheet.

Any help is very appreciated. Thank you.

Thanks CAntosh, worked perfectly!

Appreciate the help.