|
If(and) help
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 |
If(and) help
(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 |
| All times are GMT +1. The time now is 12:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com