partial lookup

[Zalabya83]

hello, i have an issue with some of my colleagues when typing for example shop names, not all of them write it the same way so i need a way to look for the written name in the excel report and look it up from the correct table.

Example:

Wrong Spelling/Name
[TABLE="width: 166"]
<tbody>[TR]
[TD]Carrfour Maadi

Correct Spelling/Name
[TABLE="width: 151"]
<tbody>[TR]
[TD]CARREFOUR MAADI SHOP[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

Probably the best you can do is a "fuzzy match".
Have a look here: https://www.mrexcel.com/forum/hall-fame-winners/69649-alans-udfs-fuzzy-match-problem.html

Going forward, it might be best to create a Validation list, where they select from a pre-defined list of names instead of manually typing them in each time.

 

[Zalabya83]

thank you for the quick reply , great solution for my dilemma , the problem with validation list is that they use online tool like google forms and they have more than 300 location to choose from that’s why they write it manually
Again thanks for the solution

 

[Joe4]

You are welcome.