View Single Post
 
Old 05-22-2017, 04:20 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I can't help you with a fuzzy search but if there were exact matches then you could apply a Conditional Formatting rule to the first sheet
Code:
=COUNTIF('SEARCH LIST 4 NAMES'!$A$1:$A$7,$A1)
I can't see how a fuzzy search could possibly work. After all, the "Judean People's Front" is very different from the "People's Front of Judea"
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote