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-bit)||168|
|PLSQL Developer 13 (32 bit)||1|| || ||Adobe Acrobat Reader DC||1954|
|Apro Banking Gateway||1|| || ||Adobe Acrobat SCCL Windows 64BIT||4|
|Articulate 360||1|| || ||Adobe After Effects 2022||1|
|ASG-Remote Desktop 2018||15|| || ||Adobe AIR||2|
|Jira Core (Server)||1|| || ||Adobe Animate 2022||1|
|Jira Software (Server)||4|| || ||Adobe Bridge 2020||1|
I have been trying to use XLOOKUP to return the value of the relevant cell in column D into column B. This works perfectly when column A and column C are an exact match.
However when there is a difference - such as Adobe After Effects 2021 in column A and Adobe After Effects 2022 in column C the XLOOKUP fails as can be seen with the #N/A in column B.
I have been trying =XLOOKUP("*"&A2&"*",C2:C9,D2:D9,,2).
Is XLOOKUP the best way of achieving this or is there a better option?