Hello everyone, I hope you are having a pleasant day!
I am not an expert Excel user, and I have been struggling to find a formula that can help me identify whether a value (in my case, text) is contained within an array.
Below the use-case:
Column D contains a sample set of "Product Names".
Column A contains a sample set of "Advertisement Titles" from eBay.
I want to know whether the product names from column D are contained in the titles from column A. The result to appear in column B, as shown below.
I tried using MATCH, SEARCH, XVLOOKUP and combinations thereof but none delivered the result I am looking for.
I am using Excel for Microsoft 365 Version 2202.
Thank you very much for your help.
I am not an expert Excel user, and I have been struggling to find a formula that can help me identify whether a value (in my case, text) is contained within an array.
Below the use-case:
Column D contains a sample set of "Product Names".
Column A contains a sample set of "Advertisement Titles" from eBay.
I want to know whether the product names from column D are contained in the titles from column A. The result to appear in column B, as shown below.
I tried using MATCH, SEARCH, XVLOOKUP and combinations thereof but none delivered the result I am looking for.
I am using Excel for Microsoft 365 Version 2202.
Thank you very much for your help.