Hi Haseeb,
Thanks for you help on this query but recently I noticed onething, this
formula works when we have to match strings from left. In this case it works
fine. But when I have the below scenario, it doesnt work properly.
For example, in source sheet I have Analex Corporation and in
:* $$Excel-Macros$$ Need help on String Matching
** **
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data populated
column A.
I want to find the best possible match in Column B on 2nd Sheet
, 2011 3:43 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need help on String Matching
** **
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data populated
column
Hey Haseeb,
This formula is AWESOME man... Tooo goood.. helped me big time..
A big THANK YOU :)
Thanks,
Anish
On Tue, Jul 12, 2011 at 8:25 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello, Try this Array Formula. Must hit CONTROL+SHIFT+ENTER, rather than
ENTER.
Shrivastava
*Sent:* Monday, July 11, 2011 3:43 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need help on String Matching
** **
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data
try this
VLOOKUP(A1*,Sheet1!$A:$A,1,0)
On Mon, Jul 11, 2011 at 3:42 PM, Anish Shrivastava anish@gmail.comwrote:
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data populated
column A.
I want to find the best possible
Hi Ashish,
This one looks great but it will only help if few of the characters at the
end of the text is missing.
For Example - Guitar Center, . (row # 1650) in the 2nd sheet is not able
to find the value because it's Guitar Center, Inc. in sheet one.
*I wanted something like which matches the