XLOOKUP (Combine matched columns from 2 files)
1. Main CSV
This is your primary CSV file where you want to add data from another CSV.
2. Lookup CSV
This CSV contains the data you want to search for and add to the main CSV. Column index to match in both CSVs and in same place or col order.
3. Lookup column index
Enter the column index in both files to match rows. Indexing starts at 0. For example, ID column = 0.
4. Return column indexes (comma separated)
Specify which columns from the lookup CSV you want to append to the main CSV. Use comma for multiple columns, e.g., 2,3,5.
5. Value return if not found
This value will be inserted in the main CSV if a match is not found in the lookup CSV. Default is "-" or "NA".
Run XLOOKUP