Data Replacement

Anonymous
2021-07-20T21:59:12+00:00

I am trying to compare two databases and replace the contents of one with more accurate data from another.

I have Sheet1:

And Sheet2:

I need to override the email address in sheet1 with the Primary Contact email from sheet2, but only if Combined Name from sheet one matches Primary Contact Name. Is this possible to do in Excel, or would I be better off using SQL to make the changes?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2021-07-20T23:25:42+00:00

The vLookup formula in Sheet1(i2) is filled down.

After filling down, the results can be copied and Values pasted into column(K).

Followed by clearing column(i) or deleting the column.

Image

=IFERROR(VLOOKUP(J2,Sheet2!F2:G8,2,0),K2)

'---
NLtL

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU (free excel programs)

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-07-21T18:50:01+00:00

    You are welcome.

    '
    NLtL

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-07-21T18:18:32+00:00

    This is perfect! Thank you so much for the response!

    Was this answer helpful?

    0 comments