How to Perform Fuzzy Match or Partial Match Lookups in Excel

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍

This video demonstrates how to perform fuzzy or partial match lookups in Excel. There are two scenarios where you might need to use a partial match:

When the lookup value is partial
When the lookup table contains partial strings.

The video covers both scenarios.

In Office 365 we can use XLOOKUP and FILTER to perform fuzzy or partial matches, but in older versions of Excel we have to use VLOOKUP, MATCH and INDEX. The SEARCH and ISNUMBER functions are also used. The video demonstrates how to use all these functions, so no matter what version of Excel you are using you will find a solution here.
------------------------

[stevedevney]

This video may go down in history as saving people as much time as the wheel!!!

[aboveduality]

This tutorial is criminally underrated, especially the index/match part of it. I am sorry so few people have seen it up to now. Many thanks to the provider.

[_VICK_]

OMG!!!! I have been looking for a fix to an issue for 3 months..3 LOOOONG MONTHS! I cannot tell you how grateful i am for this. You just saved me and my team people about 3 hours of work each month on this repetitive task we have. Thank you so much! i will be sending a thank you tip. You are awesome.

[Giorgio.]

I love your work, I found the solution I was looking for hours in method 2, thank you. Now I need to find out how to fix the spill in 74 of the 3, 500 rows that hit more than one criteria.

[GutoGerbase]

Hey mate, just would like to say thank you so very much for this tutorial. It definitely helped me a lot.

[keikiicake]

Really good tutorial. Didn't help me with what I needed but it helped me in other ventures instead.

Was just trying to find a way to find to find the mode of a range of text based off criteria that relies on a partial text lookup. was hoping to bastardize index-match and mode together and couldn't figure out how to work that into a partial text lookup. Ah well, maybe I'll figure out a way to do it in the future.

[Gullington]

Hello Chester thanks for the tutorial. If we expect multiple partial matches how can we modify the formula to grab the largest or smallest match?

[MikeMPharmaCyclist]

Chester, great overview but one major issue... the filter function is also only available in the 365 version! I'm running 2016 and don't have that function, checked Microsoft reference material and it indicates it's only available in 365.

[IshanHarshvardhan]

hi, i am unaable to input keys as a range in search function, i am using google sheets, i was hoping if you could help me out here

[halishahar]

Sir how to find text such as, Dove HairFallDmg 7ml, i want my sheet all Dmg text box. How to find it sir? without space word not working any method

[mohankumar-qyuc]

What if There is spell mistake
Ie Ice bucket to ice buket