Match

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find cells based on multiple critera, then add them 4
Formula help SUM(IF((... 3
summing a single cell across multiple worksheets 1
sumproduct 5
Oracle 9i & Windows Service Program Error 1
Oracle client not found ...- vb.net 4
if and sumproduct 14
Error Return Value from and INDEX(A:2,MATCH()) function 4

Top