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?
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.