True statement with ISNUMBER

[McNeil87]

Hello,

I have the following formula written, but it’s not returning both ‘true’ or ‘false.’ Would love for feedback:

AND(Q2=“abc”,G2=“D”,ISNUMBER(Match(k2,abc_dom,0)))
Essentially, want to say if cell Q2=abc, and g2=d (that’s true) and if cell K2 matches the list from abc_dom, return false because I don’t want the criteria included if K2 matches, but if if matches, return true

will it work if I do this?
AND(Q2=“abc”,G2=“D”,ISNUMBER(Match(k2,abc_dom,0))=FALSE

thank you!

 

[Eric W]

I'm not sure about your criteria. First trying putting NOT around your first formula:

=NOT(AND(...))

and seeing if that works for you. If not, I'll want to see what results you want for each of the 8 possible combinations.

 

[mikerickson]

What do each of the parts return seperately.
=(Q2="abc")
=(G2="D")
=ISNUMBER(MATCH(K2, abc_dom,0))

Also, is abc_dom a single column or a single row?

 

[McNeil87]

Hello,
=(Q2="abc") — true
=(G2="D") - true
=ISNUMBER(MATCH(K2, abc_dom,0)) abc_dom is a single column list

 

[mikerickson]

Crazy, but I notice there isn't an = in the OP formula.