Help with "OR" in data validation

[e_nnm_m]

I am running Excel 365. I have two named tables, one is called "Inquiry" and the second is called "JO." This is a customer service type database, where first we get an Inquiry, which we log in the Inquiry table in the column named "Inquiry Number." At some point, a decision is made on what to do with this inquiry. If it goes to the JO group, then the data entry person goes to the JO group and enters the inquiry number into the column named "InquiryNum." Now the project is tracked by this group.

Anyway, in the JO spreadsheet, I want to make sure that there are no duplicates. So I made a data validation statement:
'=COUNTIF(INDIRECT("JOLog[InquiryNum]"),INDIRECT("JOLog[@InquiryNum]"))<=2

This works!

Next, I want to make sure that there is indeed a valid inquiry number on the Inquiry sheet. So I made a validation statement:
'=COUNTIF(INDIRECT("InquiryLog[Inquiry Number]"),INDIRECT("JOLog[@InquiryNum]"))>0

This works too!

The problem is, I cannot figure out how to combine them in an "OR" statement. Can you help?

 

[pjmorris]

does this work:

=OR(COUNTIF(INDIRECT("JOLog[InquiryNum]"),INDIRECT("JOLog[@InquiryNum]"))<=2, COUNTIF(INDIRECT("InquiryLog[Inquiry Number]"),INDIRECT("JOLog[@InquiryNum]"))>0)

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Excel Forum

Help with

www.myonlinetraininghub.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.