P
P
parvus2018-12-21 16:48:05
Google Sheets
parvus, 2018-12-21 16:48:05

How to check for the presence of a value (Google Spreadsheet)?

Let's say there is a column "1" with certain values.
How can I make sure that when I try to enter a value in column "2" that is already in column "1", this cell blocks the input?
Or just painted over in any color (for example, red).
5c1ceee70e058235091601.pngps I'm using a google spreadsheet, not an ixel.
If you don’t know how to do this in a Google spreadsheet, describe the implementation scheme in ixel.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
F
Farwisdomer, 2018-12-21
@Farwisdomer

Using the MATCH function ( https://productforums.google.com/forum/#!msg/docs/... the idea is there).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question