Forum Discussion
Solved
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 ...
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
Or just LOOKUP().
=LOOKUP(2,1/(A1:E1<>""),A1:E1)
