Lookup

Built-in functions for looking up values in tables, arrays, and matrices.

Built-in

Conventional spreadsheet lookup functions

This library includes functions you see in conventional spreadsheets, like Xlookup(), Vlookup(), Index(), or Match(). These work the same way.

Notable functions

This library also includes some functions that have engineers in mind.

One example is VlookupInterpolate(), which works similarly to Vlookup(), but will interpolate between values.

Is there a function you'd like to see here?

Please, let us know.