VLOOKUP — Combine Matched Columns from 2 CSV Files
This is the file you want to add new matched columns to.
Example: if columns are ID, Name, Age, then ID = 0, Name = 1, Age = 2.
This is the file where matching values and return columns will be found.
Use the matching ID/key column from the lookup CSV.
Enter lookup CSV column indexes to append to the main file, separated by commas.