Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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")))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
How do i Match all COLUMNS? | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |