Good catch. The problem seems to be hierarchy.
Let's say on A2 I have: "28v".
On A3 I have this: "=(LEFT(INDIRECT(ADDRESS((ROW()-1);COLUMN();4));(LEN(INDIRECT(ADDRESS((ROW()-1);COLUMN();4)))-1)))" - crops 28v to 28.
On A4 I have this: "=ADDRESS(2;MATCH(A3;A1:UX1;0);4)"
It seems that the last function is somehow executed before the first one because if I change A3 manually to 28, then it works without problem.
Any idea how to fix this?
Bookmarks