Formula on multiple values help

[daveb86]

Morning all

I need help getting a formula to work which is currently in Column M of the attached file.

Basically, in column V is the type .. So if i input "NSO" in this column it will then look at the data in columns P - R and then match the code in Column Q against the code in column A and then add the quantities in column R multiplied by the value in column W against the correct code.

I have left a formula in column M which should hopefully give a little more detail in what i'm trying to achieve.

Any help in getting this working would be much appreciated.

Thanks
Dave