Replacing cells

[polska2180]

I have a column of cells is A representing account numbers. I have another sheet with old account numbers is column A and new account numbers in column B. I want, in sheet1, to compare column A to column A in sheet 2 and if there is a match replace column A in sheet1 witht the content in column B in sheet 2.

Thanks for the help

 

[kevin.philips]

Hi,

In column B of sheet1 enter this formula and copy down to the end of your range:

=if(ISNA(Vlookup(A1,Sheet2!A:B,2,False)),A1,Vlookup(A1,Sheet2!A:B,2,False))

This assumes that your list in sheet 1 starts at A1, if not change the reference twice in the formula. Other than this I'm sure you could use the Match and Offset functions to achieve your goal but I can't recreate a workbook from where I am so the method above is from memory.

Regards

Kevin

 

[polska2180]

ty