I’m trying to use xlookup function to get the corresponding values, if the certain text is matching. Following is the example, trying to use. If not right function, would you please point to the right one?
Function:
=XLOOKUP("*"&D1&"*",A1:A4,B1:B4,"Not found",2)
Any support in this regard is really appreciated!
Below is the table in excel:
>Solution :
Use partial match either before comma or after comma. Try-
=XLOOKUP("*"&TEXTBEFORE(D1,",")&"*",$A$1:$A$4,$B$1:$B$4,"Not Found",2)
