Report

How to "Teach" Excel to Learn Names? [Solved]

Ask a question HoomanCz 2Posts Monday May 22, 2017Registration date May 23, 2017 Last seen - Last answered on May 23, 2017 at 10:42 PM by HoomanCz
Greetings to all,

I'm desperate to find a solution to my tedious work. So, each day i will go through hundreds of records and change product names.

For example,
1. Blue Carpet - S
2. Small Carpet - Blue
3. 100 x 20 Carpet - Blue
4. Blue Small Carpet

For all 4 names above, i will change the name to (Small Carpet - Blue). And this is only for 1 product. There are hundreds more products to go.

I was wondering if there is a way to "teach" Excel to identify these names and input (Small Carpet - Blue) to the cell on the right without manually typing.

Thanks!
See more 
Helpful
+1
plus moins
Hi HoomanCz,

You can build a table for it, where the left column has the 'faulty' names and the right column has the 'correct' names. Then use the VLOOKUP formula to pull the 'correct' names from the table.

Example:
Sheet2
Column A
Blue Carpet - S
Small Carpet - Blue
100 x 20 Carpet - Blue
Blue Small Carpet

Sheet2
Column B
Small Carpet - Blue
Small Carpet - Blue
Small Carpet - Blue
Small Carpet - Blue

Sheet1
Column A
Blue Carpet - S
Small Carpet - Blue
100 x 20 Carpet - Blue
Blue Small Carpet

Sheet1
Column B
=VLOOKUP(A1,Sheet2!$A$1:$B$4,2,0)
Drag formula down

Best regards,
Trowa
Was this answer helpful?  
HoomanCz 2Posts Monday May 22, 2017Registration date May 23, 2017 Last seen - May 23, 2017 at 10:42 PM
WOW! This really did helped a ton, thank you so much for your time :D
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!