Help with program line

S

sungen99

=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?
 
P

Pete_UK

Your post is a bit confusing, but I think you mean:

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

though I'm not sure where G10 comes into it. Anyway, try this out and
post back to tell us if it works or not.

Hope this helps.

Pete
 
Top