Hello everyone,

I am looking to do an Index match function but want the formula to pull values that contain certain words in another cell.

This issue all stems from different naming conventions throughout the company (e.g. GE Capital is a subsidiary of General Electric). Basically I am trying to "Map" all of these to their entity names.

Example where it does not work:

I am wanting to map "GOLDMAN SACHS" to "GOLDMAN SACHS & CO". For some reason this returns a #N/A...

Example where it does:

"PPG INDUSTRIES INC" returns "PPG INDUSTRIES, INC."

Here is my formula:

=INDEX('All TRX Swen'!O:O,MATCH('12-29 Mapping'!C199,'All TRX Swen'!M:M,0))

Thank you very much for your help. I truly appreciate it!

Jasper