How To Use Excel's 4 Match Types (Partial, Exact, Fuzzy, Approximate)
Рет қаралды 22,086
Күн бұрын🔥 Are you trying to learn Microsoft Excel on KZfaq? That's the slow way... Learn Excel the FAST way, find out how here 👉 www.excel-university.com/yt
Check out 7 Excel Time Hacks Everyone Should Know here • 7 Excel Time Hacks Eve...
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.
Subscribe here 👉 kzfaq.info... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP Hacks Playlist here • VLOOKUP Hacks Series
Watch VLOOKUP vs SUMIFS Playlist here • VLOOKUP vs SUMIFS Series
Watch Dynamic Arrays playlist here • Dynamic Arrays Series
Watch Treasure Maps playlist here • Treasure Maps Series
Watch Slow to Fast playlist here • Slow to Fast Series
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
@deniseyamaguchi7225 15 күн бұрын
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!!!
@Jerrel.A Жыл бұрын
The "approximate" is definitely a time saver. Thank you very much for your dedication and inspiration!
@KephaMurage Жыл бұрын
Fuzzy match is what I was looking for. Thank you!
@KKL385 7 ай бұрын
Amazing video, love the speed and thoroughness.
@kudupi 2 ай бұрын
Wonderful explanation...learnt a lot thank you!
@Username-hg9vz Жыл бұрын
thank you so much for the explanation kind sir :)
@ThePattersonPod 9 ай бұрын
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!
@ExcelU 8 ай бұрын
Glad I could help!
@PedramPourmand Ай бұрын
Thanks!
@ravchana2393 Ай бұрын
Fuzzy match is the one!!
@stephenthompson727 Жыл бұрын
This is awesome! thank you so much for this!!!!
@ExcelU Жыл бұрын
You're so welcome!
@mehrdadazimi2298 Жыл бұрын
Awesome! 👍👍👍
@ExcelU Жыл бұрын
Thanks :)
Excel University
Рет қаралды 408 М.