Microsoft Excel 365Install

Summary

Finds rows in an Excel table where the specified lookup column matches a value. Returns the first match by default, or every match when Return All Matches is enabled.

Inputs

• Workbook (required) — Select a workbook from the list or enter its ID.
• Sheet (required) — Select a worksheet from the list or enter its ID.
• Table (required) — Select a table from the list or enter its ID.
• Lookup Column (required) — Name of the table column to search.
• Lookup Value (required) — Value to find in the lookup column.
• Return All Matches — When enabled, return all matching rows; otherwise, return only the first match.

Output shape

One or more items containing matching table rows.

By default only the first matching row is returned. When Return All Matches is enabled, all found matches are returned.

Links

• n8n community nodes installation guide