Returning a qualified drop down list
 

If my data is something like this;

A B C
Sharp ND-208U2 208 W
Sharp ND-216U2 216 W
GE GEPVp-066-G 66 W
GE GEPVc-170-MS 170 W
GE GEPVp-185-MC 185 W
GE GEPVp-200-MS 200 W
Sanyo HIP-180B2-BO-01 180 W
Sanyo HIP-190B2-BO-01 190 W
Sanyo HIP-180BA3 180 W

From the data above, I want to be able to select from a drop down list
either "Sharp", "GE", or "Sanyo". In the next cell, I want the drop down
list to only return those lines that are "Sharp", "GE", or "Sanyo", then I
want to perform lookups deeper within those lines.

Can anyone help? Please be as detailed as possible, as I am not a big macro
user...

Thanks!

Returning a qualified drop down list
 

Hi,
Check "Dependent Dropdowns from a Sorted List" at
<http://contextures.com/xlDataVal13.html

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"rlmeyers" wrote:

If my data is something like this;

A B C
Sharp ND-208U2 208 W
Sharp ND-216U2 216 W
GE GEPVp-066-G 66 W
GE GEPVc-170-MS 170 W
GE GEPVp-185-MC 185 W
GE GEPVp-200-MS 200 W
Sanyo HIP-180B2-BO-01 180 W
Sanyo HIP-190B2-BO-01 190 W
Sanyo HIP-180BA3 180 W

From the data above, I want to be able to select from a drop down list
either "Sharp", "GE", or "Sanyo". In the next cell, I want the drop down
list to only return those lines that are "Sharp", "GE", or "Sanyo", then I
want to perform lookups deeper within those lines.

Can anyone help? Please be as detailed as possible, as I am not a big macro
user...

Thanks!

Returning a qualified drop down list
 

Thanks Sébastien! Works great!

"sebastienm" wrote:

Hi,
Check "Dependent Dropdowns from a Sorted List" at
<http://contextures.com/xlDataVal13.html

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"rlmeyers" wrote:

If my data is something like this;

A B C
Sharp ND-208U2 208 W
Sharp ND-216U2 216 W
GE GEPVp-066-G 66 W
GE GEPVc-170-MS 170 W
GE GEPVp-185-MC 185 W
GE GEPVp-200-MS 200 W
Sanyo HIP-180B2-BO-01 180 W
Sanyo HIP-190B2-BO-01 190 W
Sanyo HIP-180BA3 180 W

From the data above, I want to be able to select from a drop down list
either "Sharp", "GE", or "Sanyo". In the next cell, I want the drop down
list to only return those lines that are "Sharp", "GE", or "Sanyo", then I
want to perform lookups deeper within those lines.

Can anyone help? Please be as detailed as possible, as I am not a big macro
user...

Thanks!