Forum Discussion
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 differentl...
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.
Hi Hans,
Okay no worries, I will have to work on a way to tidy up the information, thank you for your time!
Okay no worries, I will have to work on a way to tidy up the information, thank you for your time!