vlookup, edit results, paste changes back to table If I have a table on sheet 2 that consists of a1-employee name, b1-employee id, c1-employee department, d1-employee phone number. I was wondering if there is an easy way to utilize vlookup to do the following:

On sheet 1 the table layout is identical to sheet 2.
1. I want to type in the employees id no and have all the remaining fields fill in. (This part is easy when using vlookup)
2. Then I would like to make any necessary changes, like modifying the employees phone number. Then with a click of a button, the information would be posted back to the table on sheet 2 and replace the existing data with the new info. ( Challenge)

I am willing to incorporate VBA if necessary. Any recommendations is greatly appreciated. Thanks in advance.