pulling a list from another sheet as a drop down?

I don't know what to call this problem so I will just explain it.

I have 2 sheets.... Sheet1 and Sheet2.

Sheet1 contains 2 categories.... Tonnage and Type.

I have the Tonnage drop down pulling the Tonnage data from Sheet2.

I want a drop down under Type that populates with the type based on what was selected under Tonnage. Example: If someone chooses Light under Tonnage they then have the option to choose Light1 or Light2 which should pull from Sheet2. OR, If someone chooses Medium under Tonnage they then have the option to choose Medium1 or Medium2 which should pull from Sheet2. And so on for Heavy.

I added a pdf of what I have so far.

I hope this makes sense and someone can help fast.

I appreciate any help.

Thanks.

excel1.pdf

Did you try naming your lookup ranges?

@ncmay, not really sure what your talking about.

@oeldere, I am trying to follow the posts you gave me but keep getting something wrong somewhere. I'm just overall lost. I've never really had experience in excel but I'm suppose to use it for this project.... arg.