I am trying to get excel to search a workbook/(or worksheet if easier) for a matching unique value and fill in its associated data.
My first workbook has the SKU (A) filled in but not the UPC (B).
My second workbook has both the SKU (A) and the matching UPC (C) filled in.
I need to take both workbooks/(worksheets), compare the SKUs, and if a matching SKU is found, extract the UPC from Workbook 2 and fill in the UPC field in Workbook 1, and if no UPC is present in Workbook 2, then it leaves the cell in Workbook 1 blank.
Thanks in advance for all your help guys.
Chris
Bookmarks