In a cell I have values such as "cm||m||mm"
What I am looking to do is have a dropdown that would list them a "cm", "m", "mm"
The dropdown menu would be dependent on an INDEX MATCH.
I cannot amend the original data sheet to use a "Text To Columns" style. (This is a report received daily to a specified location, that the sheet I need a dropdown in references
So, Master Data Sheet (In Column H will include things like "cm||m||mm"
In my worksheet I have an INDEX Match for the Product details that I can use to determine the dropdown
MASTERSHEET
My Worksheet
What I am looking to do is have a dropdown that would list them a "cm", "m", "mm"
The dropdown menu would be dependent on an INDEX MATCH.
I cannot amend the original data sheet to use a "Text To Columns" style. (This is a report received daily to a specified location, that the sheet I need a dropdown in references
So, Master Data Sheet (In Column H will include things like "cm||m||mm"
In my worksheet I have an INDEX Match for the Product details that I can use to determine the dropdown
MASTERSHEET
Column B | Column H |
Product Name | Default UOM |
Abcde | cm||m||mm |
Fghij | h||min |
Klmno | |
My Worksheet
Column A | Column B (Need Dropdown here) | |
Abcde | (Dropdown of "cm", "m", "mm" | |
Fghij | (Dropdown of "h", "min" | |
Klmno | No details in Column H, so no dropdown needed |