Sleeper: Formula will not see both columns

[Tenspeed39355]

I am using the following foumula to see if Column A and Column B have the same
stock symbols in both. There are times I can see the stock symbol in both columns but I get a NO answer until I over type one or both of the symbols.
What is up with that? I am downloading the symbols from a web site into
Excel. The formula is =IF(ISERROR(MATCH(A1,$B$1:$B$400,FALSE)),"NO","YES")
Thanks for the help
Max

[Jacob Hilderbrand]

Maybe there is some additional text in the cell that may not be apparent like a trailing space. Can you post an attachment that shows the error?

[Tenspeed39355]

I will download the symbols and send them to you. I have looked at the symbols before

making any changes and I find nothing wrong with the spacing or anything else in the cell.

I have a friend that downloads from the same web site and he has the same problem.

[mark007]

You could try another approach too such as:


=sumif($B$1:$B$400,A1)>0,"Yes","No")

See if that gives the same problem.

:)

[Tenspeed39355]

Thanks I will try it and let you guys know

Max

[mdmackillop]

Hi Max,
Here's a wee bit code to check for non-letters in a selection
MD



Sub NL()
For Each cel In Selection
For i = 1 To Len(cel)
tmp = Asc(Mid(cel, i, 1))
If tmp < 65 Then MsgBox cel.Address & " - Code " & tmp: Exit Sub
If tmp > 65 And tmp < 97 Then MsgBox cel.Address & " - Code " & tmp: Exit Sub
If tmp > 122 Then MsgBox cel.Address & " - Code " & tmp: Exit Sub
Next
Next
End Sub