IF/MATCH statement deemed FALSE on Excel

[ElmerOmero]

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

[#2]

@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")