subject:"Re\: $$Excel\-Macros$$ Need help on String Matching"

Re: $$Excel-Macros$$ Need help on String Matching

2011-09-21 Thread Anish Shrivastava

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 Destination
I have The Analex Corp alongwith other values starting with Anal. The
best match for source string would be The Analex Corp but since there is
The at the left it's not picking it up.

Can you please suggest me any solution for this. Hope you get what I am
trying to say.
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(Sheet1!A:A,MAX(IFERROR(MATCH(LEFT(A1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1*,Sheet1!A:A,0),0)))

Copy down. See the attached.

HTH
Haseeb

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need help on String Matching

2011-09-21 Thread jmothilal

*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 anish@gmail.comwrote:

 Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)


 On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

  *=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,

  

 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 From
 Sheet 1.

  

 Since the names are not exactly matching I need your help otherwise a
 simple vlookup formula would have done the task for me.

  

 Just to simplify my query and for a better understanding I would put the
 formula which I would have used if the naming convention on both the sheets
 were same.

  

 =VLOOKUP(A1,Sheet1!$A:$A,1,FALSE) in (cell B1 - Sheet 2)

  

 It will help me in reducing the manual work and also I would learn it..**
 **

  

 Thanks,

 Anish

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need help on String Matching

2011-09-21 Thread Sam Mathai Chacko

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, Sep 21, 2011 at 5:24 PM, jmothilal gjmothi...@gmail.com wrote:

*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 anish@gmail.comwrote:

Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)

On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

*=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,

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 From
Sheet 1.

Since the names are not exactly matching I need your help otherwise a
simple vlookup formula would have done the task for me.

Just to simplify my query and for a better understanding I would put the
formula which I would have used if the naming convention on both the sheets
were same.

=VLOOKUP(A1,Sheet1!$A:$A,1,FALSE) in (cell B1 - Sheet 2)

It will help me in reducing the manual work and also I would learn it..*
***

Thanks,

Anish

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

--
Sam Mathai Chacko

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook

Re: $$Excel-Macros$$ Need help on String Matching

2011-07-19 Thread Anish Shrivastava

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(Sheet1!A:A,MAX(IFERROR(MATCH(LEFT(A1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1*,Sheet1!A:A,0),0)))

Copy down. See the attached.

HTH
Haseeb

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

To post to this group, send email to excel-macros@googlegroups.com

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need help on String Matching

2011-07-12 Thread Anish Shrivastava

Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)

On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

  *=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,

  

 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 From
 Sheet 1.

  

 Since the names are not exactly matching I need your help otherwise a
 simple vlookup formula would have done the task for me.

  

 Just to simplify my query and for a better understanding I would put the
 formula which I would have used if the naming convention on both the sheets
 were same.

  

 =VLOOKUP(A1,Sheet1!$A:$A,1,FALSE) in (cell B1 - Sheet 2)

  

 It will help me in reducing the manual work and also I would learn it..***
 *

  

 Thanks,

 Anish

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need help on String Matching

2011-07-11 Thread ashish koul

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 match in Column B on 2nd Sheet From
 Sheet 1.

 Since the names are not exactly matching I need your help otherwise a
 simple vlookup formula would have done the task for me.

 Just to simplify my query and for a better understanding I would put the
 formula which I would have used if the naming convention on both the sheets
 were same.

 =VLOOKUP(A1,Sheet1!$A:$A,1,FALSE) in (cell B1 - Sheet 2)

 It will help me in reducing the manual work and also I would learn it..

 Thanks,
 Anish

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
http://akoul.posterous.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need help on String Matching

2011-07-11 Thread Anish Shrivastava

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 first two or one Words (depending
upon the # of spaces the text has) and then match or even in between of the
text.*

Do we have anything in excel which counts the ASCII value of characters and
then matches it or anyway where we can use instr function and get the
results.

I guess I am asking for much but yet I would request for it.

Appreciate your help.

Thanks,
Anish



On Mon, Jul 11, 2011 at 5:38 PM, ashish koul koul.ash...@gmail.com wrote:

 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 match in Column B on 2nd Sheet From
 Sheet 1.

 Since the names are not exactly matching I need your help otherwise a
 simple vlookup formula would have done the task for me.

 Just to simplify my query and for a better understanding I would put the
 formula which I would have used if the naming convention on both the sheets
 were same.

 =VLOOKUP(A1,Sheet1!$A:$A,1,FALSE) in (cell B1 - Sheet 2)

 It will help me in reducing the manual work and also I would learn it..

 Thanks,
 Anish

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 http://akoul.posterous.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need help on String Matching

Re: $$Excel-Macros$$ Need help on String Matching

Re: $$Excel-Macros$$ Need help on String Matching

Re: $$Excel-Macros$$ Need help on String Matching

Re: $$Excel-Macros$$ Need help on String Matching

Re: $$Excel-Macros$$ Need help on String Matching

Re: $$Excel-Macros$$ Need help on String Matching

7 matches

Site Navigation

Mail list logo

Footer information