Forum Discussion

mat81's avatar
mat81
Copper Contributor
Apr 06, 2020

help with exchel

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

  • Savia's avatar
    Savia
    Iron Contributor

    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.

Resources