I’m trying to use lookup datatable to get the Excel file column data and insert into another Excel file column, I’m able to get the value but the value always not showing in the correct column. I have attached the file as below. Appreciate your help on this issue. Thanks.
Example as below:
If 1st excel’s Order No. = 2nd excel’s OrderNo1 and 1st excel’s itemNo = 2nd excel’s itemNo1
then get the “Position No” and insert into 1st excel.
I got the Position No but always show in the column not I want as below.
This is the result I want to show in my 1st Excel.