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!