How to match 2 row of data in excel ?

Solved/Closed
royang28 Posts 1 Registration date Thursday 16 August 2012 Status Member Last seen 16 August 2012 - 16 Aug 2012 à 04:03
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Sep 2012 à 10:43
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
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
11 Sep 2012 à 10:43
You can use MATCH function