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