•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
is there a search and replace from Main Excel Sheet, using a second excel sheet for key words to find, and replace?
Our take
If you're looking to streamline your data management, you might find yourself grappling with a common challenge: how to efficiently search for and replace model numbers in your Master Sheet using a Vendor Sheet. In this scenario, the Master Sheet contains a list of legacy model numbers, while the Vendor Sheet pairs these with their newer replacements. The goal is to seamlessly update the Master Sheet with the latest models. This task may seem straightforward, but finding the right solution can be tricky.
The challenge sounds simple, but I'm having trouble finding a solution. To all excel prodigies, this should be easy peasy.
I have a Master sheet full of model numbers (Let's call this C1) in column 1.
I have a Vendor sheet full of C1 model numbers, and a newer replacement C2 model numbers.
The challenge is that I need to use the Master Sheet, search the Vendor Sheet, and any old models are replaced with the new models.
Example:
Master Sheet:
Column 1:
A
B
C
D
Vendor Sheet:
Column 1: | Column 2:
A | Z
B | Y
C | X
D | W
What will happen is the Master Sheet will update to the following:
Z
Y
X
W
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#financial modeling with spreadsheets#natural language processing for spreadsheets#generative AI for data analysis#Excel#search and replace#Master Sheet#Vendor Sheet#model numbers#C1#C2#update#columns#replacement#data#prodigies#solution