How to compare column data from two spreadsheets to return two different results.

[snadeau456]

How to compare column data from two spreadsheets to return results from one column if a match and adds a indicated comment if no match.

Example:

Sheet1 data in cell D2 to search the entire D2 column in Sheet2 

If found to add 2042

Else No

[KGT]

I can't see any uploaded spreadsheets. Your comment 2 above seems to indicate that you want to do a couple of comparisons. I think that there's a possibility this is being overcomplicated by thinking that it has to follow a certain process rather than just trying to get the result. 

If you're doing ONE comparison, then the Find/Replace method will work and select all the fields you want to add. It will then maybe need a formula tool, if you want data from one of those columns based on a condition.