Mass Find & Replace Formula

[excel_brandon]

I have a few questions. I'm working from an excel workbook with multiple tabs.

1) On the first tab, I have a sheet of 850 rows. The sheet contains old values in Column A and the new value that I would like it replaced with in column B.

The other tabs contain many of the same "old" values, so I would like to do a mass find/replace of the column A values to the B values (from the first sheet) across all of the tabs.

Is this possible?

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[excel_brandon]

Thanks for the quick reply. See the attached sheet.

So on tab 1, the A column values needs to be changed to their corresponding B values (1 needs to be changed to ABC_123.195.10.3, etc.).

Also: All instances of the A values (on all tabs) need to be changed to the their corresponding B values.

Does that make sense?

[:) Sixthsense :)]

In B2 Cell of Old sheet

=IFERROR(VLOOKUP(A2,'Old - New'!A:B,2,FALSE),A2)

Drag it down....

Apply the above formula for the rest of the sheets Old 2, Old 3 and copy paste the Column-B Formula cells to Column-A as values

[excel_brandon]

Thanks, however I forgot to mention some important details. My apologies.

The values in the (Old-New) sheet are not identical to the values in the 'Old' sheets (there are some differences). Also: the A-column values in the old sheets aren't sequential -- so I don't think I can drag the formula down.

Please see the attached revision. Let me know if you have any questions.

[:) Sixthsense :)]

A-column values in the old sheets aren't sequential -- so I don't think I can drag the formula down.

Try the suggested solution and come back again if it fails to deliver the expected result.

[bebo021999]

It does not effect to VLOOKUP, I think...

[excel_brandon]

Thanks guys. I think this particular issue has been solved.

[:) Sixthsense :)]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[excel_brandon]

I'm still having issues. The formula (=IFERROR(VLOOKUP(A2,'Old - New'!A:B,2,FALSE),A2) is returning incorrect values on the 'Old' tabs.

Any other ideas?

[:) Sixthsense :)]

Attach a sample workbook by highlighting the cells in which it gets wrong results.

Alongwith Sheet/Cell references for fixing the issue.