LookUp Data Table with changing variable

Help
,
1

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!

2

@anon59155201
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

5

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