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.

migrated from superuser.com Feb 4 at 20:58

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

0

  • 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, privacy policy and cookie policy