I have two separate lists of addresses. One list of addresses belongs to my customers and the other list is a list of addresses I want to check my customer address list against. Each list is formatted a little different (i.e. Road - Rd). I need to find the closest match between these two addresses to see if I do have a match. A simple Vlookup does not work for me. It only finds the first closest match. I need to find the closest absolute match. Does anyone know a formula I could use? Thanks in advance!