Vlookup Question!

[spiderdoggy]

Hi! I am trying to use the Vlookup formula but receiving an #N/A. The table array consists of addresses and I am attempting to match those addresses to the master file/column addresses to determine if those addresses are equal and match. In the array table of addresses, their are no suits just the beginning of an address such as example; 200 Crescent Court. If the addresses in the master table have items such as suits etc how do I overcome this so the matches are exact?

 

[haylau]

It may be better to show an example. Show us some data as it is in the file you have, show the formula and show what you expect as a result of the formula

 

[Special-K99]

What's a "suit" apart from what I wore into work today?

 

[Eric W]

I suspect the OP means "Suite" as in "Suite 10" or "Apt. 5A".

Spiderdoggy, first, Welcome to the forum. Next, what you're asking for is called fuzzy matching, and it's a hard proposition to solve. It depends greatly on your data, how it's set up, how it's entered, etc. There are various add-ins or macros that attempt to solve this, by figuring out a percent match, as in "those 2 addresses are 83% alike, so I'm going to call it a match." These add-ins are usually pretty slow and computation intensive. But here are a few links you can look at:

https://www.microsoft.com/en-us/download/details.aspx?id=15011

That's Microsoft's take on it.


I wrote a version here:

https://www.mrexcel.com/forum/excel...d-most-similar-word-word-using-excel-vba.html


This thread has several versions.

https://www.mrexcel.com/forum/excel...zy-matching-new-version-plus-explanation.html

The problem is that the thread is so long now, it's hard to find the actual code. You may want to start at the end and work backwards to find the most recent version.

Good luck!