Hello all,
Could you please help me on below.
I am trying to Lookup a last value in row, but I can't make my range dynamic.
Capture 1.PNG
Whenever I tried to add a column, I have to modify and range as well.
Capture 2.PNG
Is it possible to make a range starting from a static cell and ending in active cell ??
Something like from B2 to OFFSET(H$2,0,-1)) ?
Thank you and best regards
Bookmarks