Options In Drop Down Menu Based On Value in another Cell

[bloodmilksky]

Hi Guys,

I currently have an order sheet for multiple customers. The AC Number goes into Sheet1 C2 and you select the product type from a drop down list in C3(the information for the list is on sheet 2 H2:H6 . )

my problem is that no matter which ac number goes into c2 you can still see all of the products. is there anyway that you can change what is shown in the drop down list in c3 depending on the value in c2?

 

[AliGW]

This tutorial is a good starting point: http://www.contextures.com/xlDataVal02.html