vlookup_helper
Perform cross-file lookups by matching keys between two Excel workbooks and returning specified columns, with optional fuzzy matching for approximate matches.
Instructions
Perform cross-file lookup akin to VLOOKUP with optional fuzzy matching.
Args:
lookup_file: Workbook containing keys to look up.
data_file: Workbook containing reference data.
lookup_column: Column in lookup_file to match.
data_key_column: Column in data_file to join on.
data_return_columns: Columns from data_file to return.
lookup_sheet, data_sheet: Sheet names.
fuzzy: If True, perform fuzzy matching.
fuzzy_threshold: Threshold for fuzzy confidence.
output_file: Optional path to write augmented lookup results.
header_row: 1-based header row index.
Returns: dict: Mapping rows to matched results and match scores.
Notes:
- Read-only on inputs unless output_file is provided.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fuzzy | No | ||
| data_file | Yes | ||
| data_sheet | No | Sheet1 | |
| header_row | No | ||
| lookup_file | Yes | ||
| output_file | No | ||
| lookup_sheet | No | Sheet1 | |
| lookup_column | Yes | ||
| data_key_column | Yes | ||
| fuzzy_threshold | No | ||
| data_return_columns | Yes |