Hi

Use a Vlookup in the first spreadsheet in an adjacent column (eg col C) along the lines of:

=VLOOKUP(A2,'[SecondWorkbook]Sheet1'!A:B,2,0)

and copy down (adjust ranges to suit if not in A & B columns). This should provide you with the corrected result. Then copy and pasteSpecial>Values over your original values. Following this you can delete the formula column.

Richard