Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 10 October 2018
  1 Replies
  5.5K 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.