Searching and changing data when com[paring two tables....

Accidently deleted previous post...

I hit a mind block here...

I am looking finding the value in a column of one dataset, and replacing it with new data taken from a second updated dataset without changing unchanged data. I have attached a copy of the workbook to help you, help me...:-)

In the "Updated" sheet, I need to use column A to find the relevant rows in column A in the "FULL" worksheet. I then need to replace the data in column F in the "FULL" data with the data in column F in the "Updated" dataset. I don't want to change any unchanged data in the "FULL" dataset, just the data that has changed.

Hope that makes sense....