Compare two Sheets and copy value

[sa02000]

I need to compare two lists and if there is a match then copy some cell
from one list to other otherwise do nothing. I need to put this in a
macro which is doing a whole bunch of other things.

So...I have sheet1 with column A,B,C,D,E,F,G,H Sheet2 with column
A,B,C,D,E,F,G,H. Now compare the values in each cell of column A in
sheet1 with value in each cell of column A in sheet2. If there is a
match, copy value from cell in same row and column H of sheet2 to same
row column H of sheet1... if no match then leave the original value in
sheet1.

Can it be done? I was trying
=IF(MATCH(A2,Dummy1!$A$2:$A$533,0)<>"#N/A",VLOOKUP(A2,Dummy1!$A$2:$H$533,8,FALSE),I8)

but this doesn't give any promising results and I don't know how to
leave the original value that was there in original cell and this
wouldn't work in a macro.......I need to put something in a macro.

Thanks, Jay

 

[Don Guillett]

Perhaps a trip to vba help index for FINDNEXT will be of help?