populate fields based upon pull down lists

[John]

I am trying to create a quote template that will auto populate the name and
pricing based upon the sku selected in a drop down list. How do I do it?

 

[Gord Dibben]

You could use Data Validation to create the drop-downs and a lookup table and
VLOOKUP formulas to return the name and pricing.

See Debra Dalgleish's site for more info on these two.

http://www.contextures.on.ca/xlDataVal01.html

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP