Wednesday, 10 October 2018
  1 Replies
  5.8K Visits
0
Votes
Undo
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.
5 years ago
·
#1741
0
Votes
Undo
Hello,
You can get it done with this feature https://www.extendoffice.com/product/kutools-for-excel/excel-compare-ranges,-rows-and-columns.html
  • Page :
  • 1
There are no replies made for this post yet.