Drop Down List Two Lists of Data

[owiccrossett]

Hi,

I have searched this column for quite a while to find a relevant
solution to my question but I still have not found it.

What I have is two lists. One names SKU and the other Description
which is description of what the Item SKU is.

In the sames workbook but in a different worksheet i am trying list
both of the fields in a drop down using the data validation. So what
I am hoping it will do is that if the user knows the SKU they can open
the dropdown and then it will populate it automically (i have
jerryrigged this by just using a vlookup); but I also want other users
that don't know what the SKU is but do know the description to be able
to select the description and have the SKU automatically populate.

Can this be done? especially without a lot of VB code?

Thanks in advance,

 

[Guest]

One play which might achieve it here would be
to use a combo box from the control toolbox toolbar

Try this sample from my archives which illustrates:
http://savefile.com/files/221672
Combo box from control toolbox toolbar_Example2.xls

As shown in the sample, you could have both Description & SKU show within
the combo box's droplist to benefit users, but only the SKU will appear in
the linked cell upon selection.

 

[Debra Dalgleish]

There's also a sample file here that uses programming and data validation:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0029 - Dependent Cell Examples'
The example is on the sheet named "Lookup up one - fill in other"