Drop Down List to return multiple results in multiple cells

Hi All,


I'm rather new to Excel and would like some help with something that might appear very simple to many.

I have created a drop down list with 4 choices on the first sheet. On the second sheet, there are 4 columns of data following the choices in the drop down list. I would like to know what is the most efficient way to have each choice in the drop down menu return their respective 4 results in sheet #1.

For example: I would like when I select the choice "Risks" in the menu, to see "AAAA", "BBBB", "CCCC", and "DDDD" appear in the 4 cells below.

See attachment for my file.

Thanks for your help with this!


Joshua

see if this works?

Thanks a lot guys, that works perfectly!