View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

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

TerriF wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html