|SHEET 1 CELL VALUE (TEXT IN CELL J:J) COPY TO SHEET 2 IF CELL IN SHEET 1 (TEXT IN CELL A:A) MATCHES CELL IN SHEET 2 (TEXT IN CELL A:A) |
in english, i have 2 sheets (first sheet is named master - the second sheet is named load). both sheets contain a part number in cell A (sheet 1 contains 3000 part numbers but sheet 2 only contains 100). on sheet 1 is a column named source that contains a value. on sheet 2 is a column named source that does not have a value. i want the value in sheet 1 to be populated in sheet 2 (source column), if the part number on sheet 1 matches the part number in sheet 2.