Excel fuzzy search

phillipus2005

New Member
Joined
Jun 29, 2018
Messages
20
Hi Excel gurus

I have a long list of company names (list a) and a shorter list of company names (list b), i'd like to search for each of the companies in list b within list a BUT need to use fuzzy search, i.e.

If list b contains "AAA BBB CCC" - need to know if list a contains either "AAA", "BBB", "CCC", "AAA BBB", "BBB CCC", "AAA, CCC", or "AAA BBB CCC" etc

any recommendations of how to do this? Have tried a countif but that only returns exact matches

thanks in advance
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,109,005
Messages
5,526,232
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top