Merging data

Occasional Visitor
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..
1 Reply

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.