Conditional Match ?

[acctlab5]

Is there a way to look for a match for the first 5 letters( or any number) of a list of names?

One of my lists has " ABC Company" and the the other list may have " ABC Co Inc".

I'm trying to find similar names in both lists.

Thanks
\db

 

[Norie]

It's certainly possible.

Could you supply some more information of what data you have and how it is structured?

Have you tried using Data>Filter>AutoFilter and then chosing (Custom) from the dropdown?

 

[Aladin Akyurek]

Is there a way to look for a match for the first 5 letters( or any number) of a list of names?

One of my lists has " ABC Company" and the the other list may have " ABC Co Inc".

I'm trying to find similar names in both lists.

Thanks
\db

You could have something like...

=MATCH(LEFT(A1,5)&"*",Range,0)

=VLOOKUP(LEFT(A1,5)&"*",Range,ColIdx,0)

However, you may still miss matches more than you'd like. Do a search on fuzzy match on this board, which would effect more hits.

 

[acctlab5]

How about this.

It would help alot if I could filter/sort (or whatever) the addresses and zip codes out.This would make the lists smaller.

How can this be done?

\db