Something along these lines, I think - put this formula in D1:

=IF(COUNTIF(A$1:A$1000,C1)0,C1,"no match")

and copy down.

This is taking the approach:

"if C1 appears anywhere in A1:A1000, then put C1 into D1"

which I think is logically equivalent to what you said.

Hope this helps.

Pete


On Nov 22, 8:15 pm, casedk wrote:
I'm having some trouble. I'd like to compare two columns and return data
from a third column when True.

For example:

Compare column A to Column C - Rows 1-1000. If A1 appears anywhere in
C1-1000 i want to return the "text" in column D. The row in D is = to the
true value in C.

i.e.

If A1=C47 I want to return the text in D47. Then repeat this for A2-A1000.

Thanks