Hi Friends,
Trying to find the solution on my task. But did not find suitable one to the need.
Here is my query and sample file with details.
Need a formula to find list of words before a (,) comma from sheet2A:A in Sheet1A:A(there is no data range like A1:a10) and extract text before the match
Formula should out put results like shown in ColumnD
ColumnC has found words from sheet2A:A in sheet1A:A
spaces.hightail.com
Trying to find the solution on my task. But did not find suitable one to the need.
Here is my query and sample file with details.
Need a formula to find list of words before a (,) comma from sheet2A:A in Sheet1A:A(there is no data range like A1:a10) and extract text before the match
Formula should out put results like shown in ColumnD
ColumnC has found words from sheet2A:A in sheet1A:A

Hightail Spaces
Hightail Spaces lets you send unlimited files, of any size, to anyone. Collaborate with your team and evolve your work.