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

employeenumber	firstname	surname	descp	code
1	a	c	d1	AS22
2	b	d	d2	ASD2

<tbody>
</tbody>

Sheet2

employeenumber	firstname	surname	descp	code
1	a	b	d1	AS22
3	bb	dd	d22	ASD2d

<tbody>
</tbody>

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