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!