I have one sheet (e.g. Sheet 1) where there are two columns:
- Enterprise Number
- Enterprise Name
and in the second sheet (e.g. Sheet 2), I have only Enterprise Name column. The problem is that the Enterprise Name in the Sheet 2 is not exactly just the name of the enterprise, but is often chopped by commas, since most cells contain both the short and the longer name of the enterprise.
So what I believe would be a good solution is to, firstly, check whether the enterprise name from Sheet 1 is contained in the column in Sheet 2, and if so - assign that enterprise number from Sheet 1 to the more general enterprise name in Sheet 2.
For example:
SHEET 1
- Enterprise Number
- EE_123123
EE_321321
Enterprise Name
- Jacob's Ent.
- Mark's Ent.
SHEET 2
- Enterprise Name
- Jacob's Ent., Jacob's Enterprise
Mark's Ent., Mark's Enterprise
Enterprise Number
- [empty]
So, as you can see, the name from Sheet 1 can be contained in the name in Sheet 2.
How would you achieve this?
Thanks for help!
INDEX/MATCH