How to match the 1st left word on diff sheet [Solved/Closed]

Report
-
 cheryl -
Hello,

I'm trying to match the exact first words from sheet 1 to sheet 2. (like the way we get the match for Vlookup formula)
I have a file which takes time for me to manually look up. Example on Sheet1 the name of a company is Nokia Services.Inc whereas on Sheet2 I just have Nokia Inc.

I wanted to match the first left words on sheet 2 using an easy formula, can anyone please help?

Many thanks in advance for looking into this!

Cheers,
Cher

6 replies

Posts
2576
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 10, 2019
383
Hi Cher,

You could use the text delimiter option (top menu > data). This will seperate your data where a space is found.

Best regards,
Trowa
Thanks...it wokrd ;) sorry for the late response!
Is there anyone who can help me with this?
TrowaD
Posts
2576
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 10, 2019
383
It would help if you would comment on the replies, so we know what you don't like about it.
Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
If you don't want to use "text to decimal" option you can use this formula, it will helps you. for this you have to add one column in both sheets or you can use this in your Vlookup by addeding one column in your reference sheet only.

=LEFT(A2,FIND(" ",A2,1)-1),

"A2" need to be changed by your cell.

Regards,
Rahul