TABLEJOIN
inner-joins two ranges on a key column in each · a deepcalc original · no excel equivalent · no sheets equivalent
signature
TABLEJOIN(left, left_key_column, right, right_key_column)
returns: array
| argument | required |
|---|---|
| left | required |
| left_key_column | required |
| right | required |
| right_key_column | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
| R | S | T | U | V | |
|---|---|---|---|---|---|
| 2 | north | 100 | |||
| 3 | south | 200 | |||
| 4 | north | 300 | north | cold | |
| 5 | south | warm |
fx
=TABLEJOIN(R2:S4, 1, U4:V5, 1) north errors
error values observed from the engine — each with a call that produces it.
| error | produced by |
|---|---|
| #VALUE! | =TABLEJOIN(2, 2, 2, 4) |
related
- DAVERAGE average of database values matching criteria
- DCOUNT counts numeric database values matching criteria
- DCOUNTA counts non-empty database values matching criteria
- DGET the single database value matching criteria
- DMAX largest database value matching criteria
- DMIN smallest database value matching criteria