Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)
Loading...
Uploader Comments (ExcelIsFun)
All Comments (22)
-
Thank you Mike...
-
Does it work for numbers? I used my formula on my own spreadsheet, but didn't work.
Can you check your private message. I sent you a link that i post on Mrexcel.
-
I am glad it helped!
-
@ExcelIsFun brilliant, thanks..........great explanation to each part of the formula too!
-
Tru this video:
Mr Excel & excelisfun Trick 54: Approximate Lookup To Return Multiple Items
-
how would you display more than 2 results - you have shown the first result and also the last result but what if there were 12 enteries that contained the text 'don' or 'cable and wireless'? I have a sheet where i want the user to be able to search 'jacket' and it should display all the different types of jacket we have. Can anyone help, i'll provide .xls file for example if you want. Thanks alot.
6:10
Excel Magic Trick 309: Partial Text Match: Why 2^15?by ExcelIsFun4,269 views- 4:11
Excel Magic Trick 318: MID Text (substring) VLOOKUP Troubleby ExcelIsFun4,242 views
- 4:36
Excel Magic Trick 321: Match Text Substringsby ExcelIsFun2,902 views
- 5:54
Excel Magic Trick 303: VLOOKUP from middle of text-stringby ExcelIsFun4,004 views
- 4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun35,062 views
- 6:26
Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each Listby ExcelIsFun24,092 views
- 4:46
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookupby ExcelIsFun68,839 views
- 7:17
Excel Magic Trick #110: Partial Text Conditional Formattingby ExcelIsFun7,206 views
- 4:56
Excel Lookup Series #12: INDEX & MATCH functions Example 2!by ExcelIsFun42,226 views
- 6:28
Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell, LOOKUP & SEARCH functionsby ExcelIsFun8,562 views
- 10:15
Excel Magic Trick #194: Grade Book Based on Percentagesby ExcelIsFun12,522 views
- 5:48
Excel Magic Trick 341 Extract Data w OFFSET & INDEX functionby ExcelIsFun12,798 views
- 14:57
SSIS - Fuzzy Lookupsby PCTeachME3,323 views
- 7:52
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteriaby ExcelIsFun19,652 views
- 7:17
Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functionsby ExcelIsFun11,266 views
- 12:43
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formulaby ExcelIsFun22,124 views
- 3:45
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCHby ExcelIsFun13,481 views
- 15:42
Excel Magic Trick 337: RANK function 10 Examplesby ExcelIsFun11,232 views
- 5:51
Excel Magic Trick #225: 2 Way Lookup With Duplicatesby ExcelIsFun10,737 views
- 10:27
Mr Excel & excelisfun Trick 54: Approximate Lookup To Return Multiple Itemsby ExcelIsFun3,727 views
If the first name and Lst name has spelling errors or space errors will it be possible to apply vlookup
zaance26 1 month ago
@zaance26 , Fuzzy Lookup will never work perfectly and will not always work with misspelled words. It may work ocassionally and other times it will not work. There is just no wway that will work 100% of the time with Fuzzy Math.
ExcelIsFun 1 month ago
Excellent vid and, subsequently, I found I can use the 1st wildcard method ("*"&A1&"*") to VLOOKUP A NUMBER (exact match) within a string of numbers when the 1st column in the table array is a concatenated list of numbers seperated by commas. I.E. I can vlookup 54321 from a concatenated cell that contains 12345, 23451, 54321. etc
fusionista 8 months ago
Cool! I am glad the video had some use.
ExcelIsFun 8 months ago