Data Validation - List Help Please

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am using data validation - list in cell F12. What I have now works, but it
could be better. The problem is that the drop down list only shows the list
of Part Numbers and no other info. Is there a way to show Part Number,
Vendor, Description, List Price and Cost. It only needs to fill in the part
number in F12. The other fields are just to help choose the correct part
number.



Cell F12 is a data validation cell that uses allow list.

The source is a named range =Prop_Parts.



=Prop_Parts refers to =parts.xls!Part_Number



The Name Part_Number in parts.xls refers to
=OFFSET(Parts!$B$3,0,0,COUNTA(Parts!$B:$B),1)



On parts.xls

Column B3 = Part Numbers

Column C3 = Vendor

Column D3 = Description

Column E3 = List Price

Column F3 = Cost



Thanks to all for the help in advance.



Dave
 
Hi Dave

Data validation will accept only one column. Though the following site
gives you an example how to'workaround' this restriction:
http://www.contextures.com/excelfiles.html#DataVal
(Have a look at the workbook Data Validation "Columns")

Basically you have to do the following
1. Combine your columns to one column for the data validation list
(using CONCATENATE)
2. After choosing a listbox entry process the worksheet_change event to
replace the listbox entry with the correct value

HTH
Frank
 
Thanks again Frank

This is a little over my head. Can you give me a little more assistance or
is there an easier way of doing the same thing?

Thanks
Dave
 
Hi Dave
if you like send me your spreadsheet and I'll create an example for
you.
Frank
 
Back
Top