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

Magnatolia

Board Regular
Joined
Jan 19, 2012
Messages
79
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.

Code:
=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!
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
FIND is case sensitive. See if this works
=IF(SUMPRODUCT(--ISNUMBER(FIND(LOWER(Street_Names),$A2)))>0,"","Err: Check Street Abbreviations")

M.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,043
Messages
5,466,198
Members
406,472
Latest member
QuarkJaguar

This Week's Hot Topics

Top