Match

G

Geir

Hello
Can anyone tell me what can be wrong?
I have data on two sheets and want to match them together


IF(ISNA(SUMPRODUCT(--('Oracle viðföng'!$C$1:$C$978=A9);--('Oracle
viðföng'!$E$1:$E$978=C9);'Oracle
viðföng'!$M$1:$M$978)>=0);IF(ISNA(SUMPRODUCT(--('Oracle
viðföng'!$C$1:$C$978=A9);--('Oracle viðföng'!$E$1:$E$978=C9);'Oracle
viðföng'!$M$1:$M$978)<=0);(SUMPRODUCT(--('Oracle
viðföng'!$C$1:$C$978=A9);--('Oracle viðföng'!$E$1:$E$978=C9);'Oracle
viðföng'!$M$1:$M$978;"N/A"))))
 
Top