Function to compare 2 workbooks column A for value comparison, True or False

I have two worksheets, that I need to check and see if the value in Sheet1!A is or isn't found in Sheet2!A:A. The values will not be cell A = Sheet2.Cell A but rather look at the entire column from Sheet2!A:A.

I have tried various functions without success:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any assistance is greatly appreciated,

K

comparisons formula in BOOK1 .....

in A2 of Sheet1 in BOOK1

Formula:

Please Login or Register  to view this content.