Extract Non-Error from a Range

Hi,

I have sample data in D2:G2, the result of an INDEX/MATCH formula.

In A2 I would like to create a formula that extracts the first non-error result that it encounters.

In my example, the results in D2 and E2 would be ignored as they are errors, and the result in F2 would be returned.

Can someone please suggest a solution?

Thanks!

Try:

Please Login or Register  to view this content.

Bonus: for the last non-error:

Please Login or Register  to view this content.