Unitalk Microsoft Excel 365 icon

Unitalk Microsoft Excel 365

Consume Microsoft Excel API

Actions17

Table → Lookup

AI-generated

Summary

Look up rows in a specified Excel table on Microsoft 365 by searching for a given value in a specific column, returning matching rows as JSON data.

Inputs

  • Workbook (required) — Select the target Excel workbook either from a list or by ID.
  • Sheet (required) — Select the worksheet within the workbook either from a list or by ID.
  • Table (required) — Select the table within the worksheet either from a list or by ID.
  • Lookup Column (required) — Specify the column name in the table to search for the lookup value.
  • Lookup Value (required) — Specify the value to find within the lookup column.
  • Options — An optional setting to return all matching rows instead of only the first match, via the boolean 'Return All Matches' parameter.

Output shape

a list of JSON objects representing the table rows matching the lookup criteria

By default, returns only the first matching row. When the 'Return All Matches' option is enabled, all matching rows are returned as separate items. If the specified lookup column does not exist in the table, the node throws an error. If no matches are found, the returned list will be empty.

Examples

Example 1: Lookup single match in a table

Set Workbook, Sheet, Table to target the desired Excel table. Set Lookup Column to 'Email' and Lookup Value to 'frank@example.com'. Leave 'Return All Matches' unset or false to get the first matching row only.

Example 2: Lookup all matches in a table

Set Workbook, Sheet, Table as before. Set Lookup Column and Lookup Value. Enable 'Return All Matches' option to true to get all rows where the specified column's value matches the lookup value.

Links

Discussion