Update value in one column based on another value in Excel

Question

I have an excel with 10,000 rows and 2 columns (ID, Name)

Each ID has a corresponding name

I would like to update the "NAME" column based on the value in the "ID" column.

If ID is 1, I would like to change the value of NAME column from John Smith to Ryan Smith. All the rows containing ID as 1 should be changed to Ryan Smith.

I wish to replace real values in the NAME column to some dummy values.

How many NAME-ID pairs are there? You might want to create a list and use VLOOKUP to assign the correct name to the ID. — Ben
There can be more than 10000 ID NAME pairs in the list. I wish to replace the real value of the NAME column with a dummy value for the corresponding ID — Rikin
All the names needs to be replaced for all the corresponding IDs — Rikin
Do you just wish to do ONE name replacement at a time, or do you have a list of replacement names to process? — Excel Hero
I wish to create dummy names for the real names present under the NAME column. For each ID (that may repeat multiple times within the ID column), I would like to replace it with a dummy name (which can be any name) — Rikin

Ben Ben · Accepted Answer · 2015-10-18T15:44:41

As you can see from the screenshot below, I created a list of all the ID-NAME pairs. In the right box you can see, how the VLOOKUP function is used.

Update value in one column based on another value in Excel

1 Answers