Thread: populate fields based upon pull down lists

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?

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

On Wed, 26 Jul 2006 14:19:03 -0700, John <John@discussions.microsoft.com> wrote:

>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?