Content: 3 different csv files
File1.csv contains desired data (1-1-1-1234567) in column C
File2.csv contains desired data (1234567-GE-1) in column C
File3.csv contains desired data (1-1-1-1234567-GE-1-1) in column I (eye, not L)
Each file is copied into Excel workbook as it's own Sheet.
The 'key' data is 1234567 and sometimes 123456
Attempting to FIND/SEARCH/VLOOKUP/INDEX the 'key' data in each sheet and return it's value along with the associated column data from each sheet.
For instance, If 1234567 exists in all 3 sheets - return associated row data from column E, F (Sheet1), column D, E, and F (Sheet2), and column G, E (Sheet3) in/to Sheet4.
Desired Results: Sheet4
It looks like most suitable tool here is Power Query if you consider that option.