Excel Dependent list

[cmyers5613]

I am trying to create a dependent list from a table and am getting an error for the dependent list. Not sure what I am missing here. The Excel sheet is attached. Thanks in advance for the help

the list in (h20) needs to be dependent on the list in (h18) based on the table on the list sheet in (A3:F7)

[dosydos]

You were close just needed to add ___ to the name.
for the data validation in H20 use this formula instead:

=INDIRECT(SUBSTITUTE(H18," ","_"))

[cmyers5613]

Thank you, that fixed the problem

[cmyers5613]

now that the dependent lists are working I am unsure how to create my next formula. this is what i am after just not sure how to convert this to an excel formula. file is attached again as well.

'= sum of[list sheet (B12)] / number of blades[list sheet(B10:E10)] x RPM [Cutter sheet (H20)]

[dosydos]

In B14:

Please Login or Register  to view this content.

is that your expected result?