VLOOKUP (Combine matched columns from 2 files)
1. Main CSV
2. Main column index
Tips: If col names are: ID, Name, Age → then index to be ID=0, Name=1, Age=2
3. Lookup CSV
From which file to find and combine
4. Lookup column index
Tips:Index of which col to find for matching. Same ID as above.
5. Return column indexes (comma separated)
Tips: Which cols you want to combine like 5,6,7 of the lookup csv file.
Run VLOOKUP