Forum Discussion
Solved
XLOOKUP wildcard matching issue
Hello, I can't figure out why the XLOOKUP formula in the attached file is returning only 1 match when there should be 3. Any ideas?
RSGrayson There were no wildcards used in your original formula. To return the first matching record that contains the lookup_value, you need to concatenate an asterisk ("*") to both the start and end of the lookup_value as follows:
=XLOOKUP("*" & [@[Medical Conditions]] & "*", VA_List[VA List of Disablities], VA_List[VA List of Disablities], "Not found", 2)If further explanation is needed, please see: https://exceljet.net/formulas/xlookup-wildcard-match-example
By the way, to the people to whom I sent messages saying I couldn't post a message, my apologies. For whatever reason, I finally was able to post a message, but I'm posting this one to see if it is still working.
