If(and) help

[sungen99]

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)

 

[Guest]

(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,"")