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

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


On Sun, 23 Apr 2006 15:37:01 -0700, ottter
wrote:

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