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.
Sheet 1:
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
Sheet 2:
Company Part Number Supplier Part Number
100235 N123456
100500 N145856
120050 N324560
130500 V496-3-405
160075 2000045
170050 4547876
180050 N554546
etc etc
=INDEX(Sheet2!A:A,MATCH(B2,Sheet2!B:B,0))
in C2 and auto-fill down will do it