I am trying to complete a vlookup to determine commonality 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 and commonalities. Is there a way to
write an excel formula with a wildcard?