Excel function changed to CSE doesn't work like eariler -

i have excel workbook i'm tring convert cse, since has lot of repeating functions , want lower size of file. of them worked, have problem 1 (it's logic):

=iferror(if(and(h4 ="";not(l4 =""));n4 /0,8; vlookup (i4;'karta projektu'!$i$7:$j$12;2;false)*h4);"") 

when applied every separate cell function works properly. changed cse function this:

=iferror(if(and(h4:h1003="";not(l4:l1003=""));n4:n1003/0,8; vlookup (i4:i1003;'karta projektu'!$i$7:$j$12;2;false)*h4:h1003);"") 

and not working properly. below explenation of i'm trying archive:

first, if h empty , l not empty, want display modified n value, else want display h value multiplied looked value sheet (it's basicly choosing currency exchenge rate). iferror not displaying if of data missing.

so part vlookup working fine. if leave h empty , put in l, cell displays 0.

the and function not work in array formulas (aka cse). nest couple of if statements desired result.

=iferror(if(h4:h1003=""; if(l4:l1003<>""; n4:n1003/0,8; vlookup(i4:i1003; 'karta projektu'!$i$7:$j$12; 2; false)*h4:h1003)); "")