Linking Drop Down Lists

cassiekillen

New Member
Joined
Jul 22, 2008
Messages
7
Here is my next problem!
I have two drop down lists in two different columns.
One is the part number and one is the actual part description.
How do I link the two so that when I click on the part the part number will actually fill in or when I click on the part number the corresponding part will fill in??
Make sense?
Thanks!
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Here's a way to return each using VLOOKUP or INDEX/MATCH.
Book1
ABCD
1Part #Part Description
21234Fetzer Valvue
35368Ball Bearings
489103-1 Oil
53421Gauze Pads
6
7Part #Part Description
85368Ball Bearings
9
10Part #Part Description
115368Ball Bearings
Sheet1


But note that to have the relevant item fill in in a dual-purpose role (i.e. Data Validation list or return the value of the corresponding item selection)will require VBA.

HTH,
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
In my example, A1:B5 is a list of Part # and their corresponding Descriptions. Each would be the basis for its respective Data Validation list.

A8 houses a data validation list of Part #'s and B8 holds a VLOOKUP that returns the relevant Part Description.

Conversely, B11 has a DV list of Part Descriptions and A11 uses INDEX/MATCH to return the corresponding Part #.

If you wanted to select a Part # in A8 and have B8 return the Part Description OR select the Part Description in B8 and have the Part # returned in A8 you would need to use VBA. Without VBA you can't have the cells do two different things.

Does that make more sense?
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,612
Members
414,080
Latest member
penguin23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top