Hi folks ... my daughter has asked for some help.
Sheet1 - The Original Price List
A1:A514 = Unique CSPC number
F1:F514 = Old Price
Sheet2 - New prices as supplied by accounting
A1:A416 = Unique CSPC (but not in same order as Sheet1)
E1:E416 = New Price
Need to update sheet1 F column with data from sheet2 E column ... where column A in sheet 1 contains the
same number as sheet2, column A.
In other words example: if Sheet1-A1 and sheet2-A27 are = then insert value sheet2-E27 into sheet1 F1
Appreciate solution
Bookmarks