Hello,

I have a problem as I'm attempting to use a formula previously provided by
Bob Phillips on 10/23/07. This is the formula:

=IF(ISNUMBER(MATCH(A2,'Sheet B'!A:A,0)),IF(ISNUMBER(MATCH('Sheet
A'!B2,'Sheet B'!B:B,0)),"Yes","No"),"Not Found")

I tried using this formula but it would not work correctly. I believe my
problem has to do with my column A data has a combination of numbers and
text, for example 45RAC60098V23. My column B data has only one text letter
such as R in which case it also uses the color red as the cell's fill color.
It may be either R(red), G (green), Y(yellow) as well. I believe the formula
would work if I only had numbers in my two columns. I appreciate any
assistance in resolving this issue.
--
By persisting in your path, though you forfeit the little, you gain the
great.