I have two sheets each with a column of street names. I'm trying to match street name cells in one sheet with any of the street names in the other sheet so that the matched entries on the first sheet can be added to the second sheet. Any suggestions?
Last edited by bjack; 07-17-2012 at 01:06 PM.
Hi
With your street names in ColumnA of eatch sheet, in B1 of Sheet2, put this.
=IF(COUNTIF(Sheet1!$A$1:$A$20,A1)>=1,"match","no match")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you Fotis for the fast & useful reply. Your suggestion worked perfectly. If this is the usual response I'll get here I believe I'm going to like this forum.
You are welcome.
Pls, mark your thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks