Need data validation to exclude certain entries based on specific lookup values

[malcolmwestt]

So what I would like is fairly simple but I can't wrap my head around how to do it.

What I would like is a data validation in G7:G. I want the parameters to be if the load temp in D7 = D then the door in G7 cannot be 2,4,6,8,10,12,14,16,18,20,22,24.

And so on and so on. So on my sheet I should not be allowed to enter an even number in G7, G14, G17, because the corresponding temp is D.

Also I would like to keep the data validation that's already entered for that column as well, I just want both if possible . The current data validation only prevents me from entering the same door number 3x.

Thanks for any advice.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

[malcolmwestt]

Thank you!

I've been having a hard time wrapping my mind around how to do this, I couldn't even think how to make an accurate thread title for what I wanted lol.

Thanks again.

[malcolmwestt]

Any help bump?

[AliGW]

You need to mock up some ecpected results to demonstrate what you want. I confess I had no idea when I looked at your workbook. Sorry!

[malcolmwestt]

Basically I want a formula that will read the load temps and not allow an even door number to be entered, if the temp is "D".

So in my image, you can see the load temps in blue are all "D", therefore the door # cannot be an even number.

Does that make any more sense?Capture.PNG

[AliGW]

In the sample workbook, please. Thanks.

[kvsrinivasamurthy]

Formula for DV in G7

=AND(COUNTIF($G$7:$G$999,G7)<3,IF($D7="D",ISODD($G7),TRUE))

Note Error alert message is changed.