Q:

Merging 2 sheets based on 1 column

I have two sheets which are in one Excel file. 

Sheet1 has style numbers with quantities
Sheet2 has style numbers with different quantities. 

Most of the style numbers match in both sheets (and they are both sorted alpha) but there are some styles that exist in one sheet and not the other and vice versa. 
What is the best way to automatically merge the 2 sheets based on style number, and then add the rows from sheet1 that are not found in sheet 2 as well? 
Is it with a vlookup? I know I can use vlookup but then the columns that are not a match in both sheets won't be copied over and I won't know. 

A:

You could use 2 VLOOKUPs, one to get the data from sheet2, and one in sheet2 to identify the numbers not found in sheet1 (by putting a filter on all the cells that return #N/A).

