Index/Match/Offset Multiple Values

Please see the attached.

I've used data validation to get a drop down in the yellow cell and an event driven macro to dynamically create the list. You will find the code by hitting Alt F11 and going to the sheet1 tab.