Does text exist in range? (I feel silly asking, but . . .)
Posted by Bob on July 26, 2001 9:17 AM
I feel silly for asking, but I am stumped as to how to determine if a text phrase exists in a range.
Say we have cells A1 through A5 in a named range "Colors" and they have the data
I want to have a VB statement that returns True or False depending on whether the lookup matches. E.g. "yellow" would return false, but "blue" would return true.