If I have column A as
Test #1
7
[Blank]
Test #2
2
Test #2b
Test #3
5
Test #3b
Test #4
And in Column B, I have the formula : =IFERROR(LOOKUP(2, 1/(ISTEXT(A$1:A1)), A$1:A1), " ") with the B10 formula then being : =IFERROR(LOOKUP(2, 1/(ISTEXT(A$1:A10)), A$1:A10), " ")
I would expect the result to be
Test #1
Test #1
Test #1
Test #2
Test #2
Test #3
Test #3
Test #3b
Test #4
However what I get is
Test #1
Test #1
Test #1
Test #1
Test #1
Test #1
Test #2
Test #3
Test #1
Test #1
The formula works perfectly well in Excel but not in calc. What am I doing wrong? Is there a what to fix the formula? or Did I stumble upon a bug?