Create Dropdown Based on partial cell content to a table of values.

[surkdidat]

In Column E I have a value, such as "Product length"

In a separate "Data" tab from KZ2:NI20 (Row 2 being the Column Headers) I have a list of values, such as "Length"

What I would like is a dropdown that takes the value "Length" from column E, and provides me with a dropdown in Column "H" that uses the table in my data table, and anything in that column is listed.

Working Sheet

Column E	Column H
Product Length	(Need dropdown values of mm, cm, m, km) etc
Packet Length	(Need dropdown values of mm, cm, m, km) etc

Data Sheet

Column KZ	Column LA	....	Column NI2
Length	Width	...	Volume
mm	mm		ml
cm	cm		l
m	m		pint
km	km

 

[sijpie]

I think I understad what you want.
At the moment cell E2 contains 'Product Length' and so H2 should have dropdown with mm, cm, m, km
If you were to change E2 to 'Volume', then H2 should automatically be modified to dropdown ml,l,pint

It would have to happen through some VBA code, but is is certainly possible