Forum Discussion
need a formula
SergeiBaklan what kind of sourcery is this? I tried to research how it works but can't even figure out how to explain what i'm seeing... 2nd argument would result either in 1 or div/0.
Second parameters always returns error or 1. LOOKUP ignores all errors and works from left to the right, thus since we lookup value 2 never will be found, LOOKUP returns the last appeared. Since we have third parameter, it returns the value form it taken for the position of last appeared in second parameter.