I have 2 datatable, variable1 = lookup value , variable2 = raw data.
1 lookup value can have multiple lines in raw data, and I only want get the values in column “ERP Invoice Number”
What I want to achieve is, lookup the 1st value in variable1 , get all the corresponded value in variable2.
Then write it in the notepad.
Example look up Billing number 462558569 will get array of
Then continue lookup 2nd value in variable1 in variable2… until the last value in variable1.
Below is variable 2, as you can see, 1 Billing number will have multiple ERP Invoice Number
I have been searching around, still cant get the answer.
The test I did, the message box produces empty result.