Troubleshoot nested excel formula

[Brock_Hardchest]

Hello,

I am trying to make a formula that looks through a range of cells and returns any cell that does not contain the word ''FALSE". The range is 1 row and 10 columns. Right now the formula works as planned except the problem is that it only iterates through the first 4 cell columns and ignores the 6 after that.

The far left column is U and has the formula: =INDEX($V13:$AE13,1,MATCH(TRUE,INDEX($V13:$AE13<>FALSE,0),0)) which I filled down, as shown it returns "error" and "ddd" as they are in the first 4 columns but "why not column Z???" and the "INCORRECT ENTRY" cells are not returned by the formula. (also, the formula returns "FALSE" when it does not find a cell without "FALSE", this is fine with me for now). Any help is appreciated.

FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
error	error	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
ddd	FALSE	ddd	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	FALSE	why not column Z???	FALSE	FALSE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	FALSE	INCORRECT ENTRY	FALSE	FALSE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	INCORRECT ENTRY	FALSE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	INCORRECT ENTRY	FALSE	FALSE	FALSE

<tbody>
</tbody>

 

[Marcílio_Lobão]

Brock_Hardchest, Good afternoon.

Here your formula is working perfectly!

"...that it only iterates through the first 4 cell columns and ignores the 6 after that...."
It's not true.
The formula works on all cells at the range $V13:$AE13.

Your formula finds the FIRST word/column different from FALSE.

Try to put some new word at AE13.
This demonstrates that your formula is working.

I hope it helps.