Hi, I have two sheets in one spreadsheets.

They are set up very similar. I wan to check to see if the contents of one cell exist in the cells in a column of the other sheet.

If it does, return true if it doesn't return false.

So once again, I have a sheet with a bunch or rows. In the first cell is a value.

in the other sheet is a bunch of rows. I want to see if the value in the cell on the first sheet exists in any of the rows in the second sheet.

Any help is appreciated.