You could use a combination of Haseeb's formula and this array formula
=INDEX(Sheet1!$A:$A,MIN(IFERROR(MATCH(RIGHT(A2,ABS(LEN(A2)+1-ROW(INDEX($A:$A,1):INDEX($A:$A,LEN(A2)&"*",Sheet1!$A:$A,0),"")))
The trick would be to identify *when* you would use either...
Sam Mathai Chacko (GL)
On Wed, S
*Dear friend,
=VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0)
please help me after vlookup"*",&a1&"*"
Thanks with
Mothilal
*
On Tue, Jul 12, 2011 at 7:31 PM, Anish Shrivastava wrote:
> Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)
>
>
> On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Ve
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(
Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)
On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma wrote:
> *=VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0)*
>
> *Use this*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anish Shrivastava
> *Se
=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 String Matching
Hello Experts,
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
