0

I'm trying to figure out how to validate data entries in one column on sheet 1 from a database I created in sheet 2. In column A sheet 1 the user is allowed to type in a string, upon completion it should check column A of sheet 2 and make sure its a valid entry and if not ask the user to re-enter the string.

Improve this question

1 Answer 1

Reset to default
-1

  • you can set up data validation from the range where you have your list of entries:

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.