Drop Down List

[tigermoth]

How do I create a drop down list for selection.

If I want the following in my drop down list :-

89901 Blue Strips 1"
89902 Blue Strips 2"
90001 Red Strips 1"
90002 Red Strips 2"

Say if I select 89902 Red Strips 2" form the drop down list and only want
89902 to appear in the cell.

 

[tigermoth]

How do I create a drop down list for selection.

If I want the following in my drop down list :-

89901 Blue Strips 1"
89902 Blue Strips 2"
90001 Red Strips 1"
90002 Red Strips 2"

Say if I select 89902 Red Strips 2" form the drop down list and only want
89902 to appear in the cell.

Correction - Say if I select 89902 Blue Strips 2" form the drop down list
and only want 89902 to appear in the cell.

 

[T. Valko]

There is a sample file here:

http://contextures.com/excelfiles.html#DataVal

Look for DV0004 - Data Validation Change