vlookup_helper
Perform VLOOKUP operations in Excel with intelligent error handling and fuzzy matching capabilities to retrieve data from lookup tables.
Instructions
Intelligent VLOOKUP setup and execution with error handling and fuzzy matching
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sourceFile | Yes | File with data that needs lookup values | |
| lookupFile | Yes | File to lookup values from | |
| lookupColumn | Yes | Column name or index to match on | |
| returnColumns | No | Columns to return from lookup table (empty = all except lookup column) | |
| fuzzyMatch | No | Enable fuzzy string matching for lookups (default: false) | |
| handleErrors | No | Auto-handle #N/A errors with fallbacks (default: true) | |
| sourceSheet | No | Sheet name for source Excel file (optional) | |
| lookupSheet | No | Sheet name for lookup Excel file (optional) |