I have some code that only works sometimes and is not reliable.
I don't know the exact syntax to use to make sure it will work all the time.

I am basically checking the value in cell E107 and comparing it with a range of values in
A20:A29 (named SYMB).

This is the code I'm using:
If Not IsError(Application.Match(Range("E107").Value, "SYMB", 0)) Then
I have gone so far as formatting cell E107 to make sure the contents are in the same format as the contents in range SYMB. There are only text values in the range and E107.

If anyone knows better code to use, I'd really appreciate knowing what it is.