How to identify first non blank cell in a dynamic row without using arrays

[excelpunk]

Hello All,

I am trying to identify first non blank cell without arrays and I am getting errors when I make the range dynamic. Here is what I did so far:

=MATCH(1,INDEX(1-ISBLANK(D2:T2),1,0),0) (this works correctly. The output is 4 and the first non empty cell is G2).
When I make the range (D2:T2) dynamic:
=MATCH(1,INDEX(1-ISBLANK(ADDRESS(ROW(D2),4)&":"&ADDRESS(ROW(D2),COLUMN(V2)-2)),1,0),0) this gives a wrong output of 1.
and then I tried:
=MATCH(1,INDEX(1-ISBLANK(INDIRECT(ADDRESS(ROW(D2),4)&":"&ADDRESS(ROW(D2),COLUMN(V2)-2))),1,0),0) and the output is again 1 which is not correct.

Where am I going wrong!

 

[Subho2706]

Can you show your problem with an example.

 

[excelpunk]