I have 2 Excel files. File 1 contains the search term, the row Studienfeld 1. File 2 contains the Row Studienfelder and the row Fächergruppen. I want to get the Fächergruppen to write in File 1 under the row Fächergruppen 1.
I played around with the Spaltenindex and so on but I dont know why it doesnt work. When I use search in the File 2 I find the term.
Found the problem. had some empty spaces before and after the search term , now I need a function to clear empty spaces around my word in the excel row