I have 2 excel sheets and both have one column that has matching data. However Sheet2 has a column of data that Sheet1 does not have and I need to input the corresponding data from Sheet2 into Sheet1 to complete it.
Match cell data in
column B on Sheet2 to a cell in
column B Sheet1.
Upon match, cell data from corresponding cell in
column C Sheet2 inputs to column C in Sheet1.
System Supplier Part Number Company Part Number Description 11120 V496-3-405 roller 11130 N554546 wheel 11140 N324560 bushing 11150 N145856 bearing 11160 N123456 castor 11170 4547876 spacer 11180 2000045 switch etc etc etc
Company Part Number Supplier Part Number 100235 N123456 100500 N145856 120050 N324560 130500 V496-3-405 160075 2000045 170050 4547876 180050 N554546 etc etc