Excel formula vlookup

hi all,

i have a situation in excel as per attached sheet. i have a table in cell range L4:M10 (coloured yellow) which details segments within a brand. in cell range B3:C5 (in red) i want a formula that captures for each brand the segments from the yellow table. i have hard coded the segments within the red section to show how i want to see the end product.

Your help would be very much appreciated.

S