Insert columns of data from sheet A into sheet B, WHERE a specific column/value is equal

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!

Hi dataLove,

With your simple setup, use the VLOOKUP function in Sheet B... so if your first Part Number is in A2, then put this formula in B2...

=VLOOKUP(A2,'Sheet A'!$A$2:$B$1000,2,0)

where 'Sheet A'!$A$2:$B$1000 is the range that will depend on your actual data...

Hope this helps,
Dennis