In this post I will describe a basic user defined function with better search functionality than the array formula in […]
This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.
Fuzzy lookup
Fuzzy lookups [UDF]
Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel CourseFormula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Free Blog Emails
Get a free PDF book!
