Formula help
I am trying to return a value using an xlookup function. However I need to have a wild card and a set value search. Any ideas folks
Forum Discussion
You will need to describe your situation a bit more fully to get much help. Perhaps this complete description of the XLOOKUP function will help, since you mention it.
Beyond that, though, you'll need to help us help you by sharing (on OneDrive or GoogleDrive) a copy of your actual workbook, pasting a link here that grants edit access.