How to get the first "true" value as the output of an IF array function?

[Rnkhch]

Hello,

Finally after a lot of attempts, I managed to write an IF array formula that correctly does the analysis I wanted as shown in the figure below:

But sadly, it shows blank after hitting cntrl+shift+enter which I think is because the first result in the array is FALSE.

However, my intention for the formula was to show the first TRUE result which is "3", and only show blank if all results were FALSE. So, what is the general trick in the syntax of an IF array function to make it show the first TRUE result?

Thanks for any input!!!

P.S. My actual formula is extremely complicated and ugly ? but I can post it if needed. But hopefully the concept can be illustrated with any simple IF array function of the responder's choice.

 

[DanteAmor]

We cannot know if there is another solution alternative.
To help with another alternative, the explanation of your data, the conditions and the result you need are necessary.

But try the following:

=SMALL(your_formula, 1)

Remember to press Control + Shift + Enter

 

[Rnkhch]

Phenomenal!!!! That was exactly what I needed!!! Thanks a lot!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.