Forum Discussion
excel formula to find value
I am looking for formula to enter in a cell that will find the first value in any column to the left of a cell. For example, if row 1 has values in column b, column c, and column d, I would like to enter a formula in column f that looks to the columns to the left and returns the value in the first column that has a value - column d in this case. If row 2 only has values in column b and c, a formula in column f would return the value in column c in this case.
Thanks
That could be
=IFNA(OFFSET(A1,0,LOOKUP(2,1/NOT(ISBLANK(A1:E1)),COLUMN(A:E))-1),"")
and attached
To clarify - your Excel is right to left or first column means one with value closest to column F?
I would like it to return the value in the column closest to col f in my example
That could be
=IFNA(OFFSET(A1,0,LOOKUP(2,1/NOT(ISBLANK(A1:E1)),COLUMN(A:E))-1),"")
and attached
