Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
×

Compare a cell to a column in another sheet to see if it exists there

More
6 months 1 week ago #1110 by Jay Chivo

Please Log in or Create an account to join the conversation.

  • Bryan Bloom
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
More
6 months 2 weeks ago #1101 by Bryan Bloom
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.

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo