VlookupInterpolate(value, table, columnIndex)


VlookupInterpolate is included by default in each file as part of the Lookup library.


See also:


The VlookupInterpolate() function returns an interpolated result from a lookup value, a range, and an index to specify the result column. It works similarly to Vlookup() in conventional spreadsheets, but the result is interpolated instead of finding the closest matching value.

The first input is the lookup value, the second input is the range or array, and the third input is the index that indicates the return value column. The left-most column in the range input is used as the lookup column, and it must be in ascending order for VlookupInterpolate() to work properly.

VlookupInterpolate() works with units. If the units for the lookup value are different than (but compatible with) the units of the lookup column, Blockpad will automatically convert the units to find the right value.

  • VlookupInterpolate(2.3, [2, 3, 4; 3, 4, 5], 3)  = 4.3
  • VlookupInterpolate(3.7, $C$3:$D$8, 2)  = 77
Example with lookup value units