Search and Update a sheet based on another

HI sir,

I have a simmiliar issue. I am working for an organization and i have been assigned a work of updating an huge excel file. I have to check wether entries in a coloumn of sheet 1 are present in same coloumn of sheet 2. if yes i need to copy the entire row from sheet 2 to sheet 1. for eg.

sheet 1

Name| Address| phone| fax
a| abc| 1121| 2565
b| dgg| 4441| 2555
c| dgs| 6661| 8585
d| ddf| 7777| 2789


sheet 2

Name| Address| phone| fax
r| arc| 1021| 2560
b| xxxx| 0000| 1111
e| dfg| 6361| 8685
d| yyyy| 2222| 5555

Considering the above as template of spreadsheet. I need to pick each and every entry under name column of sheet 1 and check if it is present in name coloumn of sheet 2. if it is present i will replace the contents of adress,phone and fax corrosponding to matched entry in sheet 2 to sheet1.i.e the resulting sheet 1 after carrying updates in the above mentioned template would be

sheet 1

Name| Address| phone| fax
a| abc| 1121| 2565
b| xxxx| 0000| 1111
c| dgs| 6661| 8585
d| yyyy| 2222| 5555


the higlighted entries are the updated entries. and rest of the entries which donot match remain unaffected. I would be really obliged if you can guide me how to go about it.

Thanks in advance. also I am try to attach the copy of my excel file but its not getting attched..kindly help and oblige. I am a pure newbie in excel

This can be done....in three steps....

i have attached the sheet for your reference and explained steps in it.

Hope this helps u

Regards,
guru

hello

thanks a lot for ur help.its has partly solved my problem. I just wanted to know if the postion of the values is differnt i.e if name a is present at 1st postion in sheet 1 and suppose 99th postion in sheet 2. will it still work..? what modifications can be made.my one sheet has 6634 values to be compared agains 48008 values in sheet 2.

thanks again.

PK