Hi,

colC and colD contain lists of stocks

C contain both the company name and the stock ticker.

Example: 1SPATIAL PLC (XLON:SPA)

D only contains the company name.

Example: 1SPATIAL PLC 

The formula should ignore the stock ticker.

Example: (XLON:SPA)

Each matching record will be in the same row.

The formula should return 1SPATIAL PLC 

There are many rows.

Checking for duplicates using conditional formatting might be the best option here, but I can be persuaded to use a different approach.

Thank you.

​Hi,colC and colD contain lists of stocks C contain both the company name and the stock ticker.Example: 1SPATIAL PLC (XLON:SPA) D only contains the company name.Example: 1SPATIAL PLC  The formula should ignore the stock ticker.Example: (XLON:SPA) Each matching record will be in the same row. The formula should return 1SPATIAL PLC  There are many rows. Checking for duplicates using conditional formatting might be the best option here, but I can be persuaded to use a different approach. Thank you.   Read More

​