There is a function that does it: VLOOKUP
For example : you have a column filled with data - column A
You have a single cell (c1) that you wish to compare to all the data in column A : vlookup(c1,a1:a27,1,false). This will just give you if there is a match or no.
but I suggest that you add another column with the number of rows so you can get immediately the row where the match appears. So let us add Column b with the numbers , and the function will become: vlookup(c1,a1:a27,2,false)