Two excel files: One has address numbers and street names (2) and the other has only Street Names (1).
I need to find which street names in (1) are also in the large database (2) that have the addresses numbers and street name
See attached sample. Windows 10, excel 2017
Thanks
One way:
=IF(ISNUMBER(MATCH("*"&$C3&"*",$A$3:$A$37,0)),"Present","")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you. So far there are no street names that match. I will have to look at database to make sure those names are present. Will let you know. Thanks again
Did you look at the attached file. There are six, in your sample.
Yes. I wasnt clear. Your file is good. I was referring to my two data files. I am going through them now to make sure there are no trim issues. Thanks
Here is the database files.
Can you see if your formula works with these? Thanks
Yep. the big difference between this file and the first is that the PARTIALS were in the second column and now they're in the first. So a wee tweak needed.
Works great. Thanks Glenn....blessings
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Thank you sir. Done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks