This is very often used when we get a table in Excel imported from some other source, or just manually copied and want to match it with another table with the same data sorted out. Using of Fuzzy Lookup solves this problem, by matching columns based on their similarity. In this case, if we use standard VLOOKUP function, it will not match this two values because it’s looking for the exact match. For example, we want to match two tables based on values in column “Name” and in a first table we have value “Michael Jackson”, while in a second table we have similar, but misspelled name “Michal Jackson”. As a result, you will get a new tab at the end of a Ribbon called “Fuzzy Lookup” and a button with the same name:Īs mentioned in the intro of the article, Fuzzy Lookup is used when we want to match two sets of data (two tables), but we don’t have exactly the same values in matching fields. Once you have installed the Add-In, next time when you open an Excel it will automatically import Add-In. In order to enable this function, Microsoft created an Add-In which can be downloaded from the following link:Īfter you have downloaded the installation file, you need to open it and install following instructions.
HOW TO USE VLOOKUP IN EXCEL 2013 TO COMPARE TWO SHEETS HOW TO
In this tutorial, you will see how to install Fuzzy Lookup Add-In, prepare data and create a Fuzzy Lookup, which can be very useful in data consolidation and save a lot of time.įuzzy Lookup is not a standard Excel function, therefore you can’t find it in your standard tabs and buttons. In daily data manipulation, there is a common need to compare two same data sets where one of them comes from some external source and can be misspelled or typed incorrectly. As an output, Fuzzy Lookup returns a table of matched similar data in the chosen column. This function is often used instead of VLOOKUP, when we want to compare two columns which have very similar data, but not exactly the same. Excel Fuzzy Lookup Add-In is used to match similar, but not exactly matching data.
0 kommentar(er)
