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.