Build 5.0.0.58 of xlsgen improves how the Lookup() function gets calculated under special circumstances.

In normal Lookup() usage, the first parameter is the value to look up, the second parameter is the vector to look into and the third parameter is the vector for return data (both vectors must have the same size and the look up vector must be sorted).

The special circumstances is the ability to pass only 2 parameters and both vectors are specified using an area, as second parameter. The first column of the area acts as a look up vector, and the last column acts as a vector for return data.

In other words, instead of passing =Lookup(2;B3:B10;C3:C10), you can pass =Lookup(2;B3:C10) and the result is the same.