Multi Conditional Sumproduct Vlookup

Easy Question for a Genius!

I would really appreciate some assistance if someone has a moment to look at the formula I have included in the description of the problem. Currently, I am generating a hash/value sign.

Formula Outline
Trying to calculate a cost based on array data, where 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 price array is different size to all other arrays.

Syntax
SUMPRODUCT(ISNUMBER(MATCH($D$9:$D$17,{"CO"},0))*ISNUMBER(MATCH($H$9:$H$17,{"C"},0))*ISNUMBER(MATCH($I$9:$I$17,{"Y"},0))*$AS$9:$AS$17*$EC$9:$EC$17*VLOOKUP($FT$9:$FT$17,$C$157:$C$167,H156,FALSE)*H42)

where

$AS$9:$AS$17 is the distance array
$EC$9:$EC$17 is the cable quantity array
$FT$9:$FT$17 is the VLOOKUP array for the cable type
$C$157:$C$167 is the cable type match relating to the price schedule
H156 refers to the offset from the cable type match in the price schedule so the vlookup draws on the right price in the appropriate year.

Assistance appreciated.
Thanks

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!
Keep it simple

FWIW this question has since been reposted: http://www.excelforum.com/excel-work...-attached.html