help with exchel

Copper Contributor
Hello! I would like your help. I have two sheets of data. On the first sheet I have three columns A. BAR CODE B.COMPANY CODE AND C. PRODUCT DESCRIPTION. In the second sheet I have the product description and bar code for some data without having the company code. Given that the bar codes are the same, how I will find the company code for the second sheet en mass and not to search individually.

 

2 Replies

@mat81 An INDEX MATCH could do this if you convert the numbers on the front sheet to actual numbers (they're currently stored as text).  I have done this in the attached file.

Τhank you @Savia !!