Vlookup , no match

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

You can use the ModifyText activity to clear the spaces:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.