Conditional Array & VLOOKUP: Example file attached

Excel Dummy Data Attached - refer red cell H24. Use formula precedent to trace from red cells H24.

Appreciate assistance. Currently, I am generating a hash/value sign.

Formula Outline
Cost=Function(conditionals in array, fibre distance in array, cable quantity in array, cable type in array, price of cable based on cable type)

Note - the price schedule is part of the VLOOKIP but is not the same size as the other arrays, but it cannot be. But obviously this creates a problem.

Assistance appreciated.
Thanks