+ Reply to Thread
Results 1 to 1 of 1

Comparing similar values ​​in the VLOOKUP function by using the Levenshtein distance

  1. #1
    Registered User
    Join Date
    03-10-2023
    Location
    Alterswilen, Switzerland
    MS-Off Ver
    Office Professional 2019
    Posts
    1

    Post Comparing similar values ​​in the VLOOKUP function by using the Levenshtein distance

    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.
    Attached Files Attached Files
    Last edited by Sigtom; 04-14-2023 at 05:16 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF Statement - where it compares similar values
    By Phlegon_of_Tralles in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-21-2022, 03:41 PM
  2. Is there a delete function similar to V-lookup
    By murphler in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2016, 09:29 AM
  3. Replies: 1
    Last Post: 04-30-2014, 05:49 PM
  4. Replies: 1
    Last Post: 10-03-2013, 03:58 PM
  5. Lookup Values, 2 Worksheets, one similar column
    By ladron in forum Excel General
    Replies: 5
    Last Post: 09-20-2012, 04:19 AM
  6. Using the lookup Function for similar items to add together
    By Brian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2006, 12:25 AM
  7. [SOLVED] Calculate the average using the Lookup function or similar
    By Lars F in forum Excel General
    Replies: 2
    Last Post: 11-22-2005, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1