how do you do this?

[ottter]

I am trying to create a pull down menu which can populate 2 other separate
cells of information in a given row which are linked to the data in the
pulldown menu. When I select a choice from the pull down menu. The pull down
menu will have about 30 selections. I want some text which I somehow link to
the data in the pull down menu to show up in a predetermined cell in the same
row as the pull down menu.

The data will be in worksheet 1 and the the pulldown menus will be in a
separate worksheet. The purpose of this is to create a Quote request form
which allows me to pick descriptions of products that will automatically
populate the part numbers and prices. There are about 30 separate pat
numbers . The quote sheet sheet will also need to have the samepull dlwon
menus in multiple rows to allow for quoting of multiple items
thanks

The key quesitons here are

 

[Gord Dibben]

Check out Help on creating a Lookup table and using the VLOOKUP Function.

Also visit Debra Dalgleish's site for more on Data Validation drop-down lists
and VLOOKUP formulas.

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

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


Gord Dibben MS Excel MVP