How to "Teach" Excel to Learn Names?
Solved/Closed
HoomanCz
HoomanCz
- Posts
- 2
- Registration date
- Monday May 22, 2017
- Status
- Member
- Last seen
- May 23, 2017
HoomanCz
- Posts
- 2
- Registration date
- Monday May 22, 2017
- Status
- Member
- Last seen
- May 23, 2017
Related:
- How to "Teach" Excel to Learn Names?
- Excel list of names - Guide
- How to create multiple sheets in excel with different names ✓ - Forum - Excel
- How to search a list of names in excel ✓ - Forum - Excel
- How to match names in excel where spelling differ ✓ - Forum - Excel
- Insert multiple pictures matching with their names in excel - Forum - Excel
1 reply
TrowaD
Updated on May 23, 2017 at 11:25 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Updated on May 23, 2017 at 11:25 AM
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.
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.
May 23, 2017 at 10:42 PM