XLOOKUP | Combine Matched Columns from 2 CSV Files

1. Main CSV

This is your primary CSV file where returned lookup columns will be added.

2. Main Match Column Index

Index starts at 0. Example: ID = 0, Name = 1, Age = 2.

3. Lookup CSV

This CSV contains the lookup key and the columns you want to return.

4. Lookup Match Column Index

This is the matching key column in the lookup CSV.

5. Return Column Indexes

Columns from the lookup CSV to append to the main CSV. Separate multiple indexes with commas.

6. Value to Return if Not Found

This value is inserted when no matching key is found. Example: -, NA, Not found.