Check multiple cells in excel move to next cell if null and if value found stop and return that value

Question

In the below excel table, I am looking for a formula/vba code will the following Problem Statement:

• If cell A2 is empty, go to cell B2, if cell C2 is empty go to cell D2. and if value is present in cell D2 return its value in results cell E2.

Answer 1

Use this formula:

=INDEX(FILTER(A2:D2,A2:D2<>""),1,1)

INDEX returns the first value of the FILTERed (=all non-empty cells) result

To select non-adjacent cells you can use this formula

=LET(data,CHOOSECOLS(A1:F1,1,3,5,6),
@FILTER(data,data<>""))