I'm having some difficulties...

I have an Excel sheet with a column that I need to match up with a column in another Excel sheet, using a column that is common to both sheets as a way to line up the rows.

Specifically, Sheet A has 2 columns: Part Number + Categories... Sheet B only has the column: Part Number. Some items in Sheet A are not present in Sheet B, and vice versa. How would I take my categories from Sheet A and insert them in a new column in Sheet B, matching them up with their associated "Part Number" ?

For example: INSERT sheetA.categories INTO sheetB.categories WHERE sheetA.partNumber = sheetB.partNumber

Any help would be HUGELY appreciated!