Unique drop down list of values based on criteria in other column(s)

Hello Community,

I am working on the ability to generate a list of equipment on a given work task based on the Equipment Make, Model, and ID#

I am using a table to list all the different pieces of equipment available to the work site. That way it is easier to add equipment to the list of possible equipment. I have been able to figure out how to generate a unique list of values in column, but has been locked up on generating a unique drop down list based on a known value in another cell.

Basically, when I select the Equipment Type I want the Equipment Model drop down to contain only the models for that type. Further, once I select a model, only the IDs that are associated with that type and model.

I have attached a spreadsheet "book 1" with the unique lists that I have generated, named ranges, and drop_down lists for your playing pleasure.

Thanks in advance for your time.