How to match the 1st left word on diff sheet

Solved/Closed
Cher - Aug 8, 2011 at 11:40 AM
 cheryl - Oct 14, 2011 at 03:53 AM
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
Related:

3 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 9, 2011 at 08:50 AM
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
0
Thanks...it wokrd ;) sorry for the late response!
0
Is there anyone who can help me with this?
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 16, 2011 at 09:54 AM
It would help if you would comment on the replies, so we know what you don't like about it.
0
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Aug 12, 2011 at 01:52 AM
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
0