Merging data

[clsek13]

Ok I have data I am trying to add to a current workbook by matching the units based on matching UPCs. How do I add this column where it pulls the correct unit based on matching column in the table. I hope this made sense..

[#2]

HI @clsek13 

There are a couple of look-up functions available in Microsoft Excel that you may use in your workbook. For example VLOOKUP(), HLOOKUP(), INDEX/MATCH etc.

Please share some sample data so a more specific solution can be suggested.

Thanks

Tauqeer