Forum Discussion

Copper Contributor

Oct 06, 2017

Solved

OR Formula

Hi looking for a formula to accomplish the follow. I have two fields that I want to search for the matching value in an array of items on another sheet. If either is within the other table I want...

Formulas & Functions

Need Help

Detlef_Lewin
Oct 06, 2017
Chase,

try this:

=MMULT(COUNTIF(Tabelle1!A:A,A2:B2),{1;1})>0

Detlef_Lewin

Silver Contributor

Oct 06, 2017

Chase,

try this:

=MMULT(COUNTIF(Tabelle1!A:A,A2:B2),{1;1})>0

Chase Hughes

Copper Contributor

Oct 06, 2017

Detlef - this worked great! Thank you!