How to "Teach" Excel to Learn Names? Solved/Closed

Question

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!

TrowaD · Answer

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
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.

How to "Teach" Excel to Learn Names?

1 response

Similar discussions

Subscribe To Our Newsletter!