LookUp Data Table with changing variable

Hi,

I want to automate a Lookupdatatable.

I have excel1 containing many Article Numbers in Column D.
I have excel2 with Even more article numbers and prices.

I now want to search every article number of the column D of excel 1 in the excel2 and give back the Price.

Lookupdatatable is asking for a specific value but I want to search every article number one by one.

Any ideas ? Thank you!

@vivian.titze
Welcome to the forum

Have a look on this following activity (inner Join is relevant for you)
Pay Attention to the returned data column sturucture as well

A more custom result can often be done with LINQ. But for helping you on this please share sample data and detailed description with us in case of need

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