So here is my delema. I have a product sheet of like 60,000 products all fall in a couple hundred different brands. Right now the brands are abbreviated and I have another excel which includes the abbreviated word and then in the next cell the full word.
How do I mass find and replace the associated abbreviation with the full word? Any help would be greatly appreciated. I have attached sample data.
Thanks to anyone who can enlighten me.
1) Open both workbooks
2) put this formula in Product List Master, Sheet1, cell I2:
=VLOOKUP(TRIM(B2), '[Manufacturer Abbreviations and full words.xls]Sheet1'!$A:$B, 2, 0)
3) Copy that cell down to the bottom of the data
4) Correct any errors
5) Copy the I2:I1000 (or whatever)
6) Click on B2 and do an Edit > Paste Special > Values
7) Clear column I.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
WOW. Thank you so much. Brilliant!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks