G
Geir
I have two sheets and want to match them together.
Example:
Sheet1.
A C
12 555
19 666
Sheet2
A C
12 555
22 333
I want to match if all numbers in Sheet2 are in Sheet1.
I am using =IF((SUMPRODUCT(--('Oracle viðföng'!$C$2:$C$1060=A3);--('Oracle
viðföng'!$E$2:$E$1060=C3);'Oracle
viðföng'!$J$2:$J$1060)=0);IF(OR(SUMPRODUCT(--('Oracle
viðföng'!$C$2:$C$1060=A3);--('Oracle viðföng'!$E$2:$E$1060=C3);'Oracle
viðföng'!$J$2:$J$1060)<0;SUMPRODUCT(--('Oracle
viðföng'!$C$2:$C$1060=A3);--('Oracle viðföng'!$E$2:$E$1060=C3);'Oracle
viðföng'!$J$2:$J$1060)>0);#REF!;"1"))
But I always get #REF
Can anybody solve this problem or have another solution?
Thanks Geir
Example:
Sheet1.
A C
12 555
19 666
Sheet2
A C
12 555
22 333
I want to match if all numbers in Sheet2 are in Sheet1.
I am using =IF((SUMPRODUCT(--('Oracle viðföng'!$C$2:$C$1060=A3);--('Oracle
viðföng'!$E$2:$E$1060=C3);'Oracle
viðföng'!$J$2:$J$1060)=0);IF(OR(SUMPRODUCT(--('Oracle
viðföng'!$C$2:$C$1060=A3);--('Oracle viðföng'!$E$2:$E$1060=C3);'Oracle
viðföng'!$J$2:$J$1060)<0;SUMPRODUCT(--('Oracle
viðföng'!$C$2:$C$1060=A3);--('Oracle viðföng'!$E$2:$E$1060=C3);'Oracle
viðföng'!$J$2:$J$1060)>0);#REF!;"1"))
But I always get #REF
Can anybody solve this problem or have another solution?
Thanks Geir