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
""

My code is below but its not working? Any ideas?



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


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=511220