How can I check a string against the Proper version of a named range?

[Magnatolia]

Hi all,

I have a list of Suburbs, and a list of street names. I want to identify where someone uses a lower case version of these. Basically I want to say, if you find an item within the string that is in the named range, let me know if it is the lowercase version.

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(LOWER(Street_Names),$A7)))>0,"","Err: Check Street Abbreviations")

This isn't working but I can't figure out why. I can't use EXACT because it will check even words that aren't in the list.

Thanks!

 

[Marcelo Branco]

FIND is case sensitive. See if this works
=IF(SUMPRODUCT(--ISNUMBER(FIND(LOWER(Street_Names),$A2)))>0,"","Err: Check Street Abbreviations")

M.