Enter this in C1
This uses VLOOKUP() to search for the value in a cell in Column A, in the range of cells B1 to B185.
If the value is not present, the VLOOKUP() formula returns the #NA error value.
The ISNA() function returns True if a value is the #NA error, hence ISNA() returns True when the value in column A is not present in column B
The IF() statement then makes one of two choices based on whether the result returned by ISNA() is True or not
If the value is True, the IF() statement returns (in this example) the text "Not present"
If VLOOKUP() finds the value, there is no error, ISNA() returns False and IF() returns the other choice, (in this example) the text "Present"
When you have entered the formula in cell C1 drag it down to extend it to row 260.
Note the $ signs in the formula - they are required to ensure that the ranges the formula refers to, remain correct when it is dragged.
Hope this helps.