drop downs in excel

[Kisred]

Hi! I need to figure out how to populate neighboring cells when an option is
selected in a drop down box. For instance, I have a table with data and I
have a new worksheet with drop downs so I can choose something from column A
on that table. I would like for the next two columns in my new worksheet to
populate with the information from column B and C in the table when an item
in the drop down menu is choosen.

Can you help?

Thanks so much!

 

[Don Guillett]

http://www.contextures.com/tiptech.html

 

[cht13er]

More specifically, you're looking at the "data validation" entries!