So close ...
Now it is finding text that is part of other words (e.g., HE in chemistry).
I tried to do a "whole word search" by including spaces around the *, but
some of the text that I want to find is separated by only a - or / from other
text. I think that a case-sensitive search would resolve my dilemma. I tried
the FIND function, but that only seems to work if you are searching for text
in one cell, not a column.

Can perfection be achieved?

"Toppers" wrote:

Try:

=IF(ISNA("A"&MATCH(A1,Sheet2!$A$1:$A$10,0)),IF(ISN A("C"&MATCH("*" & A1 &
"*",Sheet2!$C$1:$C$10,0)),"","C"&MATCH("*" & A1 &
"*",Sheet2!$C$1:$C$10,0)),"A"&MATCH(A1,Sheet2!$A$1 :$A$10,0))

You could change both searches to be "wildcard" rather thn just the column C

HTH