Data map (three dependent validation lists)

I apologize if this has been covered already, but I couldn't find it.

Here is my situation: I want to create a series of three drop-down lists in which the values in the second list are dependent upon the choice made in the first, and the third is dependent upon the choice made in the second. From the third, I need to extract a value.

What it amounts to is picking a value out of a three dimensional data table, similar to the fuel map used on auto engines.

Say I have a company that has three manufacturing departments, each with different machines. Within each department, each machine has different metal removal rates depending upon what metal is being machined.

What I need:

Choose a department in the first cell, which will then provide my choices of available machines in the second cell,

Choose a machine, which then provides a list of materials in the third cell,

Choose a material, which then populates a fourth cell with a "material removal rate" for that department, that machine, and that material.

It seems simple but my pea brain hasn't been able to figure it out.

Thanks for any and all help.

Looks like that will work.

Thank you very much.