Hi all,
I've scoured the forums and the internet in general for a solution to my problem, but can't quite find what I need.
I have a column containing part numbers and a column containing barcodes (the barcode data contains the part number and serial number seperated by "_"). The barcodes are in no particular order. I've written an INDEX MATCH formula that searches the barcode data for a part number, then populates another column with the serial number, as shown below:
A B C 1 Part # Serial Barcode 2 AAA123 11223 CCC789_9999 3 BBB456 123123 AAA123_11223 4 CCC789 9999 BBB456_123123 5 AAA123 11223 AAA123_22334 6 AAA123 11223 AAA123_33445 7 AAA123 11223 AAA123_44556
The formula used in cell B2 is:
As you can see there is a problem. I have 4 duplicate parts (AAA123) but 4 unique barcodes, and the INDEX MATCH only returns the first instance of the barcode containing that part number.Please Login or Register to view this content.
I've tried playing around with array functions like SMALL but I can't quite figure out how to get them working.
I know this would be a lot easier using VBA but for various reasons I want to avoid using macros.
Thank you in advance for you help!
Rico
Bookmarks