Match Comparison

New Contributor

I have to different inventory systems... which they have only common factor is the barcode while issuing.

 

But, they are different in stock codes, so I need to match the barcode and results the common products descriptions

2 Replies

@Frank_Brown_Swebe 

A possible solution could be Power Query. The blue dynamic tables represent your different inventory systems. The only link between these is the Barcode column. You can enter data into the blue dynamic tables. Then click in any cell of the green table and right-click with the mouse. Then select refresh and the green table displays the result.

barcode.JPG

@Quadruple_Pawn 

 

Thank you very much for this quick response. I am going to try it out and give back the feedback.

 

Thank you.