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.