I have two excel sheet. Both of them are matched with codes.
I want to match these code with time, which can be approximate and want to assign voucher number in excel 1 to corresponding match of the time in excel two.
is it possible to match two data with time in excel. I am attaching both the excel sheet for the reference
I want to match two item from the excel 1 and excel 2 and extract the corresponding voucher values to excel 2 from excel 1. First I want match the codes then corresponding to code i want to match the time and extract the voucher value.
Alternatively we can match both the code and time together ( it is to be noted that time will be diffrent most of the case so we need to match it approximate) I am attaching the excel once again for your help.