Raise your data cleaning to the next level:
We recently upgraded the FLOOKUP function to return the respective row number of a matching result.
This means that you can now combine FUZZYMATCH and FLOOKUP to give you even more useful overview of your data.
For instance, assuming that your tables are located in column A (100 rows) and B (500 rows):
- Type FLOOKUP (A1;A100,B1:B500,1,1,0.7,1,1) in column C and then, when this is done running...
- Type FUZZYMATCH (A1:A100,C1:C100) in column E.
This approach will give you the result in column C, the row number of the result in column D and the percentage similarity in column E.