Hello, brothers & sisters
I have 2 columns of companies name say (column a=38900),(column b=1000)
so how can i use a formula to do a match by their first word ?
For example,
column a
=======
abc company
volkswagen
macdonald (uk) corporation
burger
column b
========
fgj company
burger king (s) pte ltd
fereral express
macdonald (uk) corporation
column c
========
So my answer in column c should match 2.
being macdonald & burger king.
Possible ? Thanks for your help
