Lookup tables (Premium)

2D price matrices (width × height style) with lookup2d() in formulas — Premium.

Written By Floris de Vries

Last updated About 1 hour ago

Premium feature Lookup tables are available on Premium plans.

Lookup tables (also called 2D price matrices) let you price products from a grid of X and Y values — for example width × height for blinds, panels, or cut-to-size goods — without hundreds of conditional rules.

Where to find them

In the calculator builder, open the Formula step. The tabs are:

  • 4a. Custom variables

  • 4b. Lookup tables ← here

  • 4c. Formula

  • 4d. Calculation display (Premium)

What a table contains

  • Name / id – the id is used in formulas as lookup2d(table_id, x, y).

  • X field and Y field – which calculator fields feed the axes (required before you can insert the chip into a formula).

  • Price grid – first row = X axis values, first column = Y axis values, other cells = prices. Every cell must be a number.

  • Outside table range – Clamp to nearest edge (recommended) or Use default value. Prefer field min / max on number inputs if shoppers must stay inside the matrix.

Limits: up to 50 tables per calculator, up to 50×50 cells per table. Use + / − on the grid to add or remove columns and rows (column controls stay visible beside the grid).

CSV import / export

Export a table as CSV (corner cell empty, first row = X, first column = Y, other cells = prices). Import the same format to fill or replace a table quickly from a spreadsheet.

Using lookup2d in formulas

After X and Y fields are set, insert the table from the formula picker (under Lookup tables) or copy the snippet. Example:

lookup2d(price_table_1, width_m, height_m)

You can also map millimetres into the table steps, for example:

lookup2d(pg0_brutto, Math.ceil(breedte_mm / 100) / 10, Math.ceil(hoogte_mm / 100) / 10)

lookup2d works in the main formula (4c), in custom variable formulas (4a), and inside conditional if / then / else branches.

Best practices

  • Keep axes strictly ascending (e.g. 0.5, 0.6, 0.7…).

  • Set field min/max to match the table range so empty inputs do not silently clamp to an edge price.

  • Test with the Try X / Try Y preview in the table editor and with the formula price preview.

💡 Tip: Combine lookup tables with custom variables when you need shared mapping math (ceil / round) before looking up the cell.