The GENERAL LOOKUP function works almost the same as the standard VLOOKUP function of Excel. But there is one important difference. GENERAL LOOKUP also compares values that are similar. The Levenshtein algorithm is used for this. There is not only one result vector but up to 5 result vectors. Only results that are exactly the same (deviation = 0) are displayed in the first result vector (green:0). Similar results are shown from the 2nd to the 5th result vector, depending on how large the deviations (Levenshtein Distance) of the lookup value from the values of the lookup vector are. Several results can occur simultaneously in one cell of the result vector. These values are then concatenated with a pipe symbol.
Bookmarks