1001fx - NoCode functionsInstall

Overview

This node provides a "Vlookup Spreadsheet Function for Arrays" operation, similar to the VLOOKUP function in spreadsheet applications. It allows you to search for a value in the first column of an array (representing tabular data) and return the value from another specified column in the same row. This is useful for data enrichment, lookups, or joining datasets within your n8n workflows.

Common scenarios:

• Enriching records by looking up reference data (e.g., finding a product name by its ID).
• Merging two datasets based on a common key.
• Automating data validation or transformation tasks that require cross-referencing values.

Example:
Given an array of user records, you can use this node to find a user's email address by searching for their username.

Properties

Output

• json: The output will contain the result of the VLOOKUP operation. Typically, this will be the value found in the specified column for the matching row. If no match is found, the output may indicate an error or return null.
• If an error occurs (e.g., no match found, invalid input), the output will include an error field describing the issue.

Example output:

{
  "result": "Matched Value"
}

or, in case of error:

{
  "error": "No match found for the given lookup value."
}

Dependencies

• External Service: Requires access to the 1001fx API.
• API Key: You must configure the 1001fxApi credential in n8n.
• Environment: No additional environment variables are required beyond standard n8n configuration.

Troubleshooting

Common issues:

• Invalid Data Format: Ensure the "Data" property is a valid array of arrays or objects as expected by the API.
• Column Index Out of Range: If the "Column" value exceeds the number of columns in your data, an error will occur.
• No Match Found: If the "Lookup value" does not exist in the first column, the output will indicate an error.
• Case Sensitivity: If "Ignore case sensitivity" is set incorrectly, matches may not be found as expected.

Error messages:

• "No match found for the given lookup value." — Check your data and lookup value.
• "Invalid input data format." — Ensure your "Data" property is correctly structured.
• "API key missing or invalid." — Make sure your 1001fxApi credentials are set up in n8n.

Links and References

• 1001fx Documentation
• n8n Credentials Setup Guide
• VLOOKUP Function Reference (Excel)