I am building a quotation spreadsheet. There is a sheet called catalog
numbers that has product type, catalog #'s, descriptions, prices, etc...I
have used the VLookup successfully to shrink the options down by querying by
Product Type. This works good except it will only return the first row of
data. There may be 10 or 20 different catalog #'s under each product type
(product types are the class numbers that these parts are in).

I want to use a data valadation list that allows me to pull down the product
type (this is already working great). After I select the product type, I
then want Excel to copy or populate all of the catalog#'s prices, etc that
match that product type. I can then enter the quantities and generate a
quote...

Is that clear? Thanks for any help that you can give.