Forum Discussion
Jelena Golubovic
Jun 15, 2018Copper Contributor
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(AccessINVENTO...
SergeiBaklan
Jun 15, 2018MVP
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.