LinkBack URL
About LinkBacks
velu05 
Hi,
in Sheet2 Newyork is misspelled, better New york
A possible formula in C2 (Sheet2) to be copied down
=--(COUNTIF(Sheet1!$A$2:$A$100,"*"&A2&"*")>0)
Hope it helps
Edit: marketcity in A9 Sheet2 could create wrong results
Hi,
in Sheet2 Newyork is misspelled, better New york
A possible formula in C2 (Sheet2) to be copied down
=--(COUNTIF(Sheet1!$A$2:$A$100,"*"&A2&"*")>0)
Hope it helps
Edit: marketcity in A9 Sheet2 could create wrong results
Last edited by canapone; 05-26-2014 at 04:24 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks