Can someone please help me?

I just need to know how to compare a sheet2 cell to an entire sheet3 column and see if the column contains the data in the cell. The data in the column could be in the first row or the last row. It is not in a specific order. I need to know the data the is missing from sheet3.

077 = sheet2

085 = sheet3

This is the code I currently have for sheet2 cell C2:

=IF(OR(C2='085'!C1,C2='085'!C2,C2='085'!C3,C2='085'!C4,C2='085'!C5,C2='085'!C6,C2='085'!C7,C2='085'!C8,C2='085'!C9,C2='085'!C10),"Ok","Missing")

This is the code I currently have for sheet2 cell C3358:

=IF(OR(C3358='085'!C3339,C3358='085'!C3340,C3358='085'!C3341,C3358='085'!C3342,C3358='085'!C3343,C3358='085'!C3344,C3358='085'!C3345,C3358='085'!C3346,C3358='085'!C3347,C3358='085'!C3348,C3358='085'!C3349,C3358='085'!C3350,C3358='085'!C3351,C3358='085'!C3352,C3358='085'!C3353,C3358='085'!C3354,C3358='085'!C3355,C3358='085'!C3356,C3358='085'!C3357,C3358='085'!C3358,C3358='085'!C3359,C3358='085'!C3360,C3358='085'!C3361,C3358='085'!C3362,C3358='085'!C3363,C3358='085'!C3364,C3358='085'!C3365,C3358='085'!C3366,C3358='085'!C3367,C3358='085'!C3368),"Ok","Missing")

There has to be an easier way. As I go down farther I have to add a previous cell and a following cell.