Excel 2010, displaying a range of data

Hi, I’m currently trying to create a drop down list and have it display a range of data based on my selection from that list. So far I’ve been able to find out how to display a single value, but nothing more. 

For Example, I have a sheet with my drop down list that has all the options listed. Upon selecting one of the options, I’d like it to populate a table with all corresponding data to that option.

 

I currently have 1 sheet setup with the drop down, and another sheet setup with all the options in separate columns and their corresponding data per column. I’d like to pull that corresponding data per column after selecting it from the drop down menu.

 

Is this possible? 

 

By: Blake

Leave a Reply

Your email address will not be published. Required fields are marked *