We help IT Professionals succeed at work.
Get Started

Forcing multiple data validations?

Ryan Rood
Ryan Rood asked
Last Modified: 2015-03-03
Here is my issue. In Cell G29 G30 G31 G32 G33 I have a list of values in a hidden sheet that they can key in a specific value from the list (this works). It uses data validation to confirm the value entered is in the list.

What I need to do now is add a second validation that checks to see if there is a value <> 0 in H29 H30 H31 H32 H33. If there is a value in H then check to make sure there is something keyed into G.

It doesn't matter how this is accomplished as long as it works.

Any thoughts? Is VB script in the sheet the best route? Is there a simple way I am not thinking about? Keeping in mind that I have no coding experience.

Watch Question
Social distance - Wear a mask - Don't touch your face - Wash your hands for 20 seconds
Most Valuable Expert 2017
Distinguished Expert 2020
This problem has been solved!
Unlock 1 Answer and 16 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE