false positives - what formula to use to search for text in formula in 365

[numbers2023]

Hi,
I have a range of data and want Excel to return "False" if false is found and "Balanced if it is balanced. 1. This is the formula I'm using, it looks ok, but when I go to change the answer in AW144 to "False" to test the formula, the results aren't reflecting the change. What am I doing wrong?
=IFERROR(INDEX($C148:$AW148,MATCH("False",$C148:$AW148,"False")),"Balanced")


2. Lastly, on a different tab, I am trying to return a result from each tab in the workbook to look at the same ranges AY144:AY148 to return "False" if there are instances of "False" in the tabs within the workbook. What's the best way to find out if there are any "False" values in AY144:AY148? Thanks.

 

[arthurbr]

One way

=IF(countif($C148:$AW148,"False"),"False","Balanced")

In the MATCH function the match type is 1 or 0 or -1. When using FALSE, do not use double quotes MATCH("False",$C148:$AW148,False)

 

[numbers2023]

Thanks @arthurbr but it works within the tab, but not on my summary tab where I use that same formula to report back if any of the cells within tab "Y" has any False results. When I use the same formula you provided above, I get a false positive, it's showing "Balanced" even though I changed AQ146 to "False". The result in AY148 shows "False", but on the summary, it's still showing as "Balanced". What formula should I use?

This was expected, which is correct

This is not what was expected

Excel formula that was used to get the ROY vs Prior Fcst results: =IF(COUNTIF('ROY vs. Prior Fcst'!AY144:AY148,"False"),"False","Balanced")