Please help if you can!
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! |
Please help if you can!
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! |
All times are GMT +1. The time now is 11:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com