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.

1 Answer 1


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

Your Answer

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