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

(sorry if posted multiple times)
Hi,
i believe you forgot to close the parenthesis of the AND( ) function just
before the second Vlookup:
=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,"")

--
Regards,
Sébastien
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"sungen99" wrote:


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