Decompiled Code For VLOOKUP( C124, D$124:F$126, 3.0 )

The expression

=VLOOKUP( C124, D$124:F$126, 3.0 )

is compiled to the following class(es):

package org.formulacompiler.gen;
import org.formulacompiler.runtime.Computation;
import org.formulacompiler.runtime.FormulaException;
import org.formulacompiler.runtime.internal.Environment;
import org.formulacompiler.runtime.internal.RuntimeDouble_v2;
import org.formulacompiler.tests.reference.base.Inputs;
import org.formulacompiler.tests.reference.base.Outputs;

final class $Root extends Outputs implements Computation
{
    private final Inputs $inputs;
    final Environment $environment;
    private boolean $arr$0$init;
    private double[] $constarr$0;

    $Root(Inputs inputs, Environment environment) {
        $environment = environment;
        $inputs = inputs;
    }

    final double get$0() {
        return $idx$0(RuntimeDouble_v2.fun_MATCH_Ascending(get$1(), $arr$0())
                      - 1);
    }

    public final double dbl() {
        return get$0();
    }

    final double[] $arr$0() {
        if (!$arr$0$init) {
            $arr$0$init = true;
            double[] ds = $constarr$0();
            ds[0] = get$2();
            return ds;
        }
        return $constarr$0();
    }

    final double[] $constarr$0() {
        if ($constarr$0 == null)
            $constarr$0 = new double[] { 0.0, 20.0, 30.0 };
        return $constarr$0;
    }

    final double $idx$0(int i) {
        switch (i) {
        case 0:
            return get$3();
        case 1:
            return 22.0;
        case 2:
            return 23.0;
        default:
            throw new FormulaException
                      ("#VALUE/REF! because index is out of range in INDEX");
        }
    }

    final double get$1() {
        return $inputs.dbl(0);
    }

    final double get$2() {
        return $inputs.dbl(1);
    }

    final double get$3() {
        return $inputs.dbl(3);
    }
}