| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Match
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")))) |
|
#2
|
|||
|
|||
|
See Chip's site www.cpearson.com He has lots of stuff on comparing sheets.
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Geir" wrote in message ... 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")))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
