Forum Discussion
XLOOKUP with Wildcards
Can I use a wildcard to return data based on a partial match? A B C D Adobe Acrobat DC 7 Adobe Acrobat DC 7 Adobe After Effects 2021 #N/A Adobe Acrobat DC (64-b...
In general formula works. What you try to do is find
"anything" & "Adobe After Effects 2021" & "anything" in column C - there is no such text in it.
Perhaps you need helper column where to keep only "core" text from column A (e.g. "Adobe After Effects") and lookup based on it.