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.

migrated from superuser.com Feb 4 at 20:58

This question came from our site for computer enthusiasts and power users.


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

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.