•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?
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]
Want to read more?
Check out the full article on the original site
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