I have a worksheet with drop boxes in the first two columns of a table. The
user selects two options (manufacturer and product) and the row should fill
in the appropriate items from a data table. My search items are in colomn A
and B. How can I do this? There are quite a few different products and
manufacturers.


Thanks,

Todd