That's an excellent approach Alkey, but you need to be careful with states like Arkansas, which contains another state name (Kansas), so ideally the longer name needs to appear lower in the list than the shorter (like West Virginia and Virginia), otherwise you'll never get Arkansas returned......or if the state names will always have Upper case first letters you could use FIND instead of SEARCH
Bookmarks