Matching variable to column name and then copying another value

Help Activities
,
1

Hi all.

I have a problem that I need help please.

I have many files, which I will use for each file in folder to open. When doing so, I read a name and a number from each file, and save them to two variables.

How then do I match this name variable to the columns in another excel file?

After doing this match, I then need to write the number variable into a cell at a row directly below the matched column.

Please help.

2

@Fh1

Can you please share some expected input and output…

To start ita better you create a datatable with both values you need and use them to checkt hem on all other files

Cheers