How to match 2 row of data in excel ? [Solved/Closed]

Posts
1
Registration date
Thursday August 16, 2012
Status
Member
Last seen
August 16, 2012
- - Latest reply: rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Sep 11, 2012 at 10:43 AM
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
See more 

1 reply

Best answer
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
755
1
Thank you
You can use MATCH function

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 5769 users have said thank you to us this month