Populate Drop-Down List From Criteria

[heron]

Hi

I am attempting to create a drop-down list which populates based on the value in another cell. For example, if cell A1 has the value "Supplier A" in it, then the drop-down list in cell B1 will contain all the products supplied by Supplier A. The issue I am having is the table on a separate sheet lists the products in a single column with column A) Supplier, column B) Product and column C) Type. The table is sorted by product type and so a supplier may appear at various intervals as you go down the list. Any assistance will be greatly appreciated.

Regards

Heron

 

[marshy3300]

Column D add =if(sheet1!$a$1=a2,b2,"")
Than drop box D in B1

 

[heron]

Thank you! Works perfectly.