Choosing one variable from two columns

[Nativus_N00b]

Hello,

I have two columns with formula’s. One row on column L has #N/A as output and column N for example ‘Boodschappen’. The next row can be vice versa. There is always one #N/A in the row.

Is there a way to automatically select the value not being #N/A from the two columns?

Thanks

[PKG]

IFNA()

[Nativus_N00b]

So simple, thank you.

Do you also have a suggestion for abovementioned example but with three columns (where two columns will have #N/A).

IFNA() only works with two columns I see.

Thanks again

[dscheikey]

For two N/A Columns you can use IFNA() in IFNA().

=IFNA(L1;IFNA(M1;N1))

[Nativus_N00b]

@dscheikey

=IFNA(L1;IFNA(M1;N1))

Indeed, thanks, much appreciated.