Populate Drop-down list based on selection from previous drop-down list

OK, I found a file close to what I am looking for in This Thread

but I am trying to add costs to the final selection - see attached 20121211 DependentLists reference costs.xlsx

Not sure how to read that, maybe an IF reference, or VLookup?...

I need blanks for the groupings, but the drop downs aren't ignoring them.

I can't get the subtrade drop down selection to be dependent upon distance either.

I have attached a file, I hope you can show me the light!