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
Bookmarks