Hi All,
I have 2 Excel file, I want to get the column result “Position” if the 1st excel’s Order No. = 2nd excel’s OrderNo and 1st excel’s ItemNo = 2nd excel’s ItemNo, if both condition is match, then I want to input the “Position” into 1st excel. Below is my sample file but i always getting the same result as below screenshot. Is anyone know what is the reason? Thanks.
Main.xaml (16.9 KB) – this is the first way
Main(1).xaml (10.0 KB) – this is the second way
Completed_1st.xlsx (16.3 KB) Completed_2.xlsx (25.9 KB)