I have 2 features that I need to compare and if a matching address is found, calculate a field to indicate that a match was found. Likely just "Y" would work in that field to indicate the match. The issue I have is that the Latitude and Longitude aren't even close to matching so a spatial join or near tools do not appear to be an option. Most solutions I have seen for this involve using a join of some kind but in this case I don't have a common field I can reliably use. The only field that might match is the address, but, by the nature of the data set it is going to be iffy. Any suggestions are welcome and appreciated.
If I the best path forward is to join based on the address is there a "best practice" to help ensure the chances of a match being made or a tool that can help standardize the data?
