Filter base on another list with not exact names.

[srizki]

Hi All,

How do I filter a list based on another smaller list, the problem is that the names on the two lists are not exactly same, there are difference with comma, periods etc. but the first name is the same in both lists, like, BP, Devon, Diamond, etc.
I used the advanced filter but it matches the exact.

Thanks

 

[sheetspread]

Use fuzzyvlookup:

https://www.mrexcel.com/forum/excel...zy-matching-new-version-plus-explanation.html

and then the advanced filter

 

[srizki]

Thanks

 

[sheetspread]

the first name is the same in both lists

If so, then:

Excel 2010
	A	B
1	First name is	First
2	The same	The
3	In both lists	In
Sheet9

Cell Formulas
Range	Formula
B1	=LEFT(A1,FIND(" ",A1,1)-1)

 

[srizki]

Thank you.