Compare two sheets with lots of columns

[khandu]

Hi All

N00b to excel

I have a excel file with two sheets with some HR type data.. so we can consider column A for both sheets (say Sheet1 and Sheet2) to contain employeenumber

Now what I want to do is

1) Find if Sheet2 contains employeenumber (A in both sheets) - some kind of vlookup?
2) And if the match is found.. match all the columns for that match between both sheets..

Eg..

Sheet 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]employeenumber[/TD]
[TD]firstname[/TD]
[TD]surname[/TD]
[TD]descp[/TD]
[TD]code[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]c[/TD]
[TD]d1[/TD]
[TD]AS22[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]b[/TD]
[TD]d[/TD]
[TD]d2[/TD]
[TD]ASD2[/TD]
[/TR]
</tbody>[/TABLE]

Sheet2

[TABLE="width: 500"]
<tbody>[TR]
[TD]employeenumber[/TD]
[TD]firstname[/TD]
[TD]surname[/TD]
[TD]descp[/TD]
[TD]code[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]d1[/TD]
[TD]AS22[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]bb[/TD]
[TD]dd[/TD]
[TD]d22[/TD]
[TD]ASD2d[/TD]
[/TR]
</tbody>[/TABLE]

So in above example I would like to see

1) employeenumber 1 matches on both sheet but surname does not match
2) Employeenumber 2 is missing in sheet2 and 3 in sheet1 (and thus none of the other columns will match)

If we can do some visual codes like colour or N/A something which will make sorting easier that will be helpful.

Thanks