I have two sheets, I would like to find and match both sku's on both sheets, if the sku from sheet1 matches the sku from sheet2, i want to extract a column from sheet 2.
Sheet1:
<tbody>
</tbody>
Sheet2:
<tbody>
</tbody>
Notice the last number, sheet1 will not have all of the sku's from sheet2, Sheet2 has over 5000 products, sheet1 has around 1000. So i would like to take the information from sheet2 to fill in sheet1 or create a new sheet that gives me the sku's and QOH.
Hope this makes sense.
Thank you in advance.
Sheet1:
SKU | QOH |
1008 | 0 |
1011 | 0 |
1013 | 0 |
2135 | 0 |
<tbody>
</tbody>
Sheet2:
SKU | QOH |
1008 | 4 |
1011 | 6 |
1013 | 10 |
2954 |
<tbody>
</tbody>
Notice the last number, sheet1 will not have all of the sku's from sheet2, Sheet2 has over 5000 products, sheet1 has around 1000. So i would like to take the information from sheet2 to fill in sheet1 or create a new sheet that gives me the sku's and QOH.
Hope this makes sense.
Thank you in advance.