INDEX/MATCH not working for some values

jjg279

We have been creating a pharmacy inventory system where we scan in items and fill out the relevant information for the items in a form for our incoming stock:

Then we made a second sheet for items going out that only includes the barcode. I was then planning to populate the rest of the information using INDEX/MATCH from our incoming sheet:

And for some reason my formula isn't returning the value sometimes. Any ideas as to why?

Here is my formula:

=IFERROR(INDEX({Name-Conc}, MATCH(Barcode@row , {Barcode}, 0), 1), "Not in Inventory")

Any help much appreciated!

Corey W.

@jjg279 You could try checking the numbers you are entering with the barcode scanner. I think I ran into issues with them coming through as a string, '123445, instead of whatever number. Maybe that is throwing off your Index/match. You could try a helper column with the VALUE() function to turn them into numbers.