looks up the first non-zero value from column
Q till the end in row
And it displays the value present in that cell. Suppose the cell found is
I must display the value in cell
I cannot change the range to lookup the first non-empty cell, because the higher rows are always filled.
There probably are two possible answers
One answer that looks up 3 rows higher (10-7=3) and another answer that looks up in the fixed row
I need the last option.