Index Match function

Copper Contributor

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

1 Reply

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.