Forum Discussion

AaronCAD's avatar
AaronCAD
Copper Contributor
May 24, 2023

Xlookup

Hi All,

 

So I've got the following formula =XLOOKUP(C1,$K:$K,$L:$L,0)  to check a name on one list and give me back a value that corresponds, the problem is that the names are formatted differently. How do I adjust it so that it can recognize when the name match's if the second name comes first rather than second. Thanks 

 

 

 

.

Formulas and Functions

3 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 24, 2023

    AaronCAD 

    I have received your private message.

    I fear that there is no built-in way to handle such fuzzy matches, and even Microsoft's Fuzzy Lookup add-in will probably find only part of the matches.

    • AaronCAD's avatar
      AaronCAD
      Copper Contributor
      May 25, 2023
      Hi Hans,

      Okay no worries, I will have to work on a way to tidy up the information, thank you for your time!
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 24, 2023

    AaronCAD 

    Still cannot read the screenshot. I repeat:

     

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.