Hi All,

With the following data on two excel sheets ,I wanted to Compare sheet1 and sheet2 column(empl no) and display common column values on sheet 3 with the status.Can anyone help on this?


Sheet1
------ ------
Emp No Status
------ ------
2 open
3 open
5 close
6 open


Sheet2
------ ------
Emp No Status
------ ------
2 open
3 open
5 open
6 open
7 open



output:

Sheet3
---------------------------------------------------
sheet1Emp No Status sheet2Emp No Status
---------------------------------------------------
2 open 2 open
3 open 3 open
5 close 5 open
6 open 6 open