CODEWITHSUNDEEP
excel
Rikin
Rikin

Reputation: 275

Update value in one column based on another value in Excel

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

Each ID has a corresponding name

ID | NAME
1 | John Smith
2 | Rob More
1 | John Smith
2 | Rob More
3 | Ben Jackson
3 | Ben Jackson

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.

Upvotes: 0

Views: 12755

Answers (1)

Ben
Ben

Reputation: 175

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.

enter image description here

Upvotes: 1

Related Questions