IF/MATCH statement deemed FALSE on Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2271118%22%20slang%3D%22en-US%22%3EIF%2FMATCH%20statement%20deemed%20FALSE%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2271118%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20stuck%20with%20an%20IF%2FMATCH%20statement%20I'm%20using.%20I%20have%20used%20a%20similar%20one%20in%20a%20previous%20column%20that%20did%20work.%20The%20next%20time%20I%20tried%20it...FALSE.%20I've%20try%20and%20rewrite%20it%20but%20no%20success.%20Anyone%20has%20some%20feedback%20to%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20providing%20a%20worksheet%20with%20the%20issues%20previously%20stated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2271118%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I'm stuck with an IF/MATCH statement I'm using. I have used a similar one in a previous column that did work. The next time I tried it...FALSE. I've try and rewrite it but no success. Anyone has some feedback to it?

 

I'm providing a worksheet with the issues previously stated

 

Thanks in advance

 

 

1 Reply

@ElmerOmero 

MATCH returns the index of the first occurrence.

The first 1 in BASE!A2:Y2 is in column I, so MATCH(1,BASE!A2:Y2,0) returns 9.

The formula you want is

 

=IF(OR(BASE!A2=1,BASE!F2=1,BASE!K2=1,BASE!P2=1,BASE!U2=1,BASE!Y2=1),"Yes","No")