Folks,
Kindly requesting your help to find a formula to search and returns adjacent column value using XLOOKUP. The issues is some of the cells contains multiple lookup values separated by "/". I have attached the sample workbook for more details.
Thanks in advance.
Joshi
Bookmarks