=IF(B6<>"",VLOOKUP(B6,'Trade History'!$C$10:$L$6655,4,FALSE)*$C$3,"")


This only does part of what i need it to do. i actually need it to do this:

(trade execution sheet) if B6....<>""
AND
(trade history sheet) if H10...= (trade execution sheet) $C$4
THEN
(trade history sheet) if G10 * (trade execution sheet) $C$3
ELSE
""

this is a bit above me....... anyone?