I wanted to have formula in G3 =

From range J3:L3 find the first value which value is NOT "" so since from range J3:L3 the first non "" value is the one in K3 (the value is "GDNdynamic") so then the G3 will return to value in K3 (surely not J3 or L3 instead, because they have value of ""), which is "GDNdynamic"

I have tried the formula =ArrayFormula(INDEX($J3:$L3,MATCH(FALSE,ISBLANK($J3:$L3),0))) in G3

but it only worked if the the cell is literally BLANK, not "" , so that's why it didn't work.

Please help on what would the formula be? And to be humbly honest I don't prefer the manual formula one since I will add more and more cell to the right later on.

Thanks a lot

enter image description here

  • the operator for does not equal is <> – PeterH Jul 15 at 11:42

Try in cell G3:


You don't have to enter as array!

Also, note: =ArrayFormula(... is a google-sheets function.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.