I’m trying get the the result using Vlookup, please find the sample as below.
This it the first Data I have in 1st Excel file
This is the second data I have in 2nd Excel file
I want to insert “Position No.” into 1st Excel if the Order No. = OrderNo1 and ItemNo = itemNo1.
Is it possible to get it using VLOOPUP? Appreciate your help on this. Thanks.