Searching a cell for unique values

[abrig005]

I'm using the following formula =IF(ISNUMBER(SEARCH("1a.",,$AK2)), "Yes", "No")
To search with a cell for 1a.

The problem is I get a Yes in cells with 11a. or 111a.

What is the tick to find 1a. and 11a. and 111a. distinctly?

Thank you!

 

[Kerryx]

use EXACT("1a.",$AK")

=IF(EXACT("1a.",$AK2),"yes","no")

 

[bobsan42]

check this post: https://stackoverflow.com/questions/28100969/excel-exact-word-matching

 

[abrig005]

Thanks for the replies.
I realized that I didn't provide a key point.
The text may look like this: 1a.xxxxxxxxxxxxxxxxx;#11a.xxxxxxxxxxxxxxxxxx or 4a.xxxxxxxxxxxxxx;#14a.xxxxxxxxxxxxx
So EXACT doesn't yield and results and my original formulas produces too many results.

 

[Kerryx]

use EXACT("1a.",$AK")

=IF(EXACT("1a.",$AK2),"yes","no")

My mistake read that question wrong..

 

[jtakw]

I realized that I didn't provide a key point.
The text may look like this: 1a.xxxxxxxxxxxxxxxxx;#11a.xxxxxxxxxxxxxxxxxx or 4a.xxxxxxxxxxxxxx;#14a.xxxxxxxxxxxxx

Hi,

What does the Number symbol ( # ) represent? An actual Number or literally the # symbol?

And, is the string you're looking for (i.e. 1a) Always at the beginning?

 

[bobsan42]

if you are looking to find the string to the left of the dot you could use:

=[COLOR=#333333]IF(LEFT($AK2,SEARCH(".",$AK2))="1a.", "Yes", "No")[/COLOR]

Still, have a look at the code in the link I posted above.