Hello. I am trying to complete a vlookup to determine commonalities
between two
lists of addresses. The problem I face is that the addresses in the
two lists are not written in the same format (e.g. one list may spell
out "North" while the other just has "N."). Due to this, a simple
vlookup will not return hardly any commonalities. Is there a way to
write an excel formula with a wildcard? Or, would this be better done
in MS Access? Thanks!

Already replied to your other post.

" wrote:

Hello. I am trying to complete a vlookup to determine commonalities
between two
lists of addresses. The problem I face is that the addresses in the
two lists are not written in the same format (e.g. one list may spell
out "North" while the other just has "N."). Due to this, a simple
vlookup will not return hardly any commonalities. Is there a way to
write an excel formula with a wildcard? Or, would this be better done
in MS Access? Thanks!