I think there's a function that compares two text values and determines if
they are "similar." For instance ABC would be considered a match with ZABC.
Is anyone familiar with this function? Thanks in advance.

A few more examples of what you consider to be matches would be helpful.

***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

I think there's a function that compares two text values and determines if
they are "similar." For instance ABC would be considered a match with ZABC.
Is anyone familiar with this function? Thanks in advance.

Thanks Ron. Somethings like:
LAC vs. 2LAC
FULT vs. FULTUS
DB vs. DBK
Thinks like that?

"Ron Coderre" wrote:

A few more examples of what you consider to be matches would be helpful.

***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

I think there's a function that compares two text values and determines if
they are "similar." For instance ABC would be considered a match with ZABC.
Is anyone familiar with this function? Thanks in advance.

Here are a couple options.....

For a value in A1 to find in B1

This formula matches TEXT entries in B1 (12ABC, xyz, etc):
C1: =COUNTIF(B1,"*"&A1&"*")0

OR
This formula matches any kind of entry in B1 (56, abc, a99b, etc)
C1: =ISNUMBER(SEARCH(A1,B1))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

Thanks Ron. Somethings like:
LAC vs. 2LAC
FULT vs. FULTUS
DB vs. DBK
Thinks like that?

"Ron Coderre" wrote:

A few more examples of what you consider to be matches would be helpful.

***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

I think there's a function that compares two text values and determines if
they are "similar." For instance ABC would be considered a match with ZABC.
Is anyone familiar with this function? Thanks in advance.

Thank you Ron. I tried this, but it basically indicated a match if ANY
letter was in common with the two cells. I'd like to see if the text string
in A1
matches to any part of the text string in B1. Which is why I want ABC &
2ABC to be a match, and ABC & ABCUS to be a match. However, I would not
want "ABC" and "A Contracting Services" to match. Basically, MATCH only if
the entire text string from A1 matches some part of B1.

"Ron Coderre" wrote:

Here are a couple options.....

For a value in A1 to find in B1

This formula matches TEXT entries in B1 (12ABC, xyz, etc):
C1: =COUNTIF(B1,"*"&A1&"*")0

OR
This formula matches any kind of entry in B1 (56, abc, a99b, etc)
C1: =ISNUMBER(SEARCH(A1,B1))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

Thanks Ron. Somethings like:
LAC vs. 2LAC
FULT vs. FULTUS
DB vs. DBK
Thinks like that?

"Ron Coderre" wrote:

A few more examples of what you consider to be matches would be helpful.

***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

I think there's a function that compares two text values and determines if
they are "similar." For instance ABC would be considered a match with ZABC.
Is anyone familiar with this function? Thanks in advance.

Jim

Perhaps I'm missing something....
Here's a table of values and results using the various techniques:

Whe
COUNTIF refers to this formula in C1: =COUNTIF(B1,"*"&A1&"*")0
SEARCH refers to this formula in C1: =ISNUMBER(SEARCH(A1,B1))
FIND refers to this formula in C1: =ISNUMBER(FIND(A1,B1))

Col_A Col_B COUNTIF SEARCH FIND
lac 2LAC TRUE TRUE FALSE
FULT FULTUS TRUE TRUE TRUE
DB DBK TRUE TRUE TRUE
LAC LAWK FALSE FALSE FALSE
FULT 3FULAT FALSE FALSE FALSE
DB FALSE FALSE FALSE

Which of those returned values is incorrect?
***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

Thank you Ron. I tried this, but it basically indicated a match if ANY
letter was in common with the two cells. I'd like to see if the text string
in A1
matches to any part of the text string in B1. Which is why I want ABC &
2ABC to be a match, and ABC & ABCUS to be a match. However, I would not
want "ABC" and "A Contracting Services" to match. Basically, MATCH only if
the entire text string from A1 matches some part of B1.

"Ron Coderre" wrote:

Here are a couple options.....

For a value in A1 to find in B1

This formula matches TEXT entries in B1 (12ABC, xyz, etc):
C1: =COUNTIF(B1,"*"&A1&"*")0

OR
This formula matches any kind of entry in B1 (56, abc, a99b, etc)
C1: =ISNUMBER(SEARCH(A1,B1))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

Thanks Ron. Somethings like:
LAC vs. 2LAC
FULT vs. FULTUS
DB vs. DBK
Thinks like that?

"Ron Coderre" wrote:

A few more examples of what you consider to be matches would be helpful.

***********
Regards,
Ron

XL2002, WinXP


"JimK" wrote:

I think there's a function that compares two text values and determines if
they are "similar." For instance ABC would be considered a match with ZABC.
Is anyone familiar with this function? Thanks in advance.

On Wed, 7 Jun 2006 12:47:02 -0700, JimK wrote:

I think there's a function that compares two text values and determines if
they are "similar." For instance ABC would be considered a match with ZABC.
Is anyone familiar with this function? Thanks in advance.

You could use the FIND function to determine if the shorter text string is
contained within the longer text string.

Is that what you want?


--ron