need to populate several cells based on drop down menu selection

[TerriF]

I have created a validation drop down menu for specific options and I am now
trying to automatically populate different cells in this worksheet based on
the option chosen.

 

[Debra Dalgleish]

You can use a VLookup formula to return the matching values. There's an
example here:

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