*",Sheet1!A:A,1,0)*
>>>
>>> *Use this*
>>>
>>> * *
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Anish Shrivastava
>>> *Sent:* Monday, July 11, 2011 3:43 PM
>
cros@googlegroups.com] *On Behalf Of *Anish Shrivastava
>> *Sent:* Monday, July 11, 2011 3:43 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Need help on String Matching
>>
>> ** **
>>
>> Hello Experts,
>>
>>
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 Destin
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.
>
>
> =INDEX(
s@googlegroups.com] *On Behalf Of *Anish 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
=VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0)
Use this
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anish Shrivastava
Sent: Monday, July 11, 2011 3:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help on Strin
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 t
try this
VLOOKUP(A1&"*",Sheet1!$A:$A,1,0)
On Mon, Jul 11, 2011 at 3:42 PM, Anish Shrivastava wrote:
> 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 i
