deepcalc
DocsTABLEJOIN

TABLEJOIN

View as markdown/docs/functions/tablejoin.md Ask Claude about this pageOpens Claude with this page's address

Inner-joins two ranges on a key column in each.

  • Origin: A deepcalc original
  • Excel: No equivalent
  • Google Sheets: No equivalent
  • Returns: Array

Examples

=TABLEJOIN(R2:S4, 1, U4:V5, 1)
RSTUV
2 north100
3 south200
4 north300northcold
5 southwarm
Result north

Syntax

TABLEJOIN(left, left_key_column, right, right_key_column)
left
range required
left_key_column
number required
right
range required
right_key_column
number required

Errors

#VALUE!
=TABLEJOIN(2, 2, 2, 4)
DAVERAGEAverage of database values matching criteria. DCOUNTCounts numeric database values matching criteria. DCOUNTACounts non-empty database values matching criteria. DGETThe single database value matching criteria. DMAXLargest database value matching criteria. DMINSmallest database value matching criteria.