Hi

not sure if this is the best way to approach this, but one option would be
(ensure both files are open)
in File 1 column C use the formula
=IF(ISNA(VLOOKUP(A2,[File2]Sheet2!$A$2:$B$20,2,0)),B2,VLOOKUP(A2,[File2]Sheet2!$A$2:$B$20,2,0))
and copy the formula down (move your cursor over the bottom right hand
corner of the cell, when you see a +, double click) all of column C in File
1 - this will put the value in from File 2 if there is one, or it will put
the value in from column B if the value isn't found in File 2.

Once you've checked the results in column C, you can copy them and then edit
/paste special - values back over column B if you so wish.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"THT" wrote in message
...
Hi,

This is a follow up question to a previous question I had around macros.
Not sure if I should use a macro or a function in this case.

I have File 1 (master file) with a total of 1000 rows, and File 2 (which
contains 20 of the 1000 rows) -- identical columns

For example:

File 1

Name ID
A 1
B 2
C 3
D 4
E 5

File 2
Name ID Changed (extra column)
A 1 No
C 6 Yes
D 4 No

How can I create a macro/function to only change the ID cell for "C"? I
have inserted a "changed" column in File 2 to help me identify those that
have changed.

Thanks!