How To Use Excel's 4 Match Types (Partial, Exact, Fuzzy, Approximate)

In this video, explore Excel’s lookup capabilities, including approximate matches, partial matches, fuzzy lookups, and exact matches. The built-in Excel lookup functions, such as VLOOKUP, are amazing. When implemented in the right way for special projects or in recurring use workbooks, they are able to save a ton of time. However, the VLOOKUP function, similar to Excel’s other lookup functions, is built to perform an exact match or a range lookup. Both of these are quite different from an approximate match or a fuzzy lookup. This video discusses the details of these ideas and demonstrates how to perform each of Excel's 4 match types.

Chapters:
00:00 How To Use Excel's 4 Match Types (Partial, Exact, Fuzzy, Approximate)
00:27 Exact Match
03:13 Approximate Match
06:03 Partial Match
Fuzzy Match
14:35 Recommended Video for You

[KephaMurage]

Fuzzy match is what I was looking for. Thank you!

[Jerrel.A]

The "approximate" is definitely a time saver. Thank you very much for your dedication and inspiration!

[KKL]

Amazing video, love the speed and thoroughness.

[deniseyamaguchi]

Fuzzy match is exactly what I needed and am so glad you did this quick video! Brilliant and thank you for saving so much time since I was manually hunting through my data!!!

[ThePattersonPod]

I knew about the ribbon add in for fuzzy match, but i hadn’t done it in power query. No ribbon add in needed, thanks!

[Username-hgvz]

thank you so much for the explanation kind sir :)

[kudupi]

Wonderful explanation...learnt a lot thank you!

[stephenthompson]

This is awesome! thank you so much for this!!!!