How do I assign a set of values to a selection from a drop list?

M

Mike Bach

Hi. I am trying to assign a set of values, in separate fields ,to a each
selection from a drop-down list in Excel (using data validation). What I am
trying to do is very smilar to, say, to selecting a SKU from a list and
having the product description, unit price etc. fill into their corresponding
fields automatically. For example, I pick SKU "11111" from a drop-down list
to fill the SKU field, then, automatically, "5-inch widget" comes up in the
product description field and "$5.00" shows up in the unit price field.
Please help.
 
G

Gord Dibben

Mike

Along with the drop-down list you need a VLOOKUP table to return the values such
as description and price.

See Debra Dalgleish's site for more on VLOOKUP and a downloadable sample file.

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


Gord Dibben MS Excel MVP

On Tue, 7 Mar 2006 09:01:28 -0800, Mike Bach <Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top