Jun 15 2018
07:29 AM
- last edited on
Jul 31 2018
08:28 AM
by
TechCommunityAP
Jun 15 2018
07:29 AM
- last edited on
Jul 31 2018
08:28 AM
by
TechCommunityAP
I've used match (and index) function for getting numbers from access database pulled in another excel sheet.
I've noticed that it doesn't work properly, here is a case:
=IFERROR(INDEX(AccessINVENTORY!$K$2:$N$5243;MATCH(J$6&$E$1&7;AccessINVENTORY!$L$2:$L$5243&
AccessINVENTORY!$K$2:$K$5243&AccessINVENTORY!$M$2:$M$5243;0);4);0)
This function matches 1st,2nd and 3rd column and returns result from 4th column. But this specific function doesn't work for -18782054,99 (doesn't matches bolded 7 in function), but for matching 8, it returns 22957928,67 properly. I can't solve this, because I don't see the reason why function doesn't "see" only that. I've tried with formatting, but nothing happened.
11 | 7 | 5 | 0 |
11 | 7 | 6 | 0 |
11 | 7 | 7 | -18782054,99 |
11 | 7 | 8 | 22957928,67 |
Jun 15 2018 07:44 AM
Hi Jelena,
Without seeing the file it's hard to say why 1177 doesn't match and 1178 matches. Perhaps you could reproduce in a small sample to share here.