Forum Discussion

Jelena Golubovic's avatar
Jelena Golubovic
Copper Contributor
Jun 15, 2018

Index Match function

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

  • 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.

Resources