This problem is to use vba solve the problem of matching a many-to-many, somewhat similar to the function of the vlookup function, but we all know vlookup can only the first value, the following is a real work problems, we had a different order, the supplier will have the same supplier, same material, for orders in different time period, then we do the goods receipt, also split into, what we want to make sure the order is put in storage, as shown in figure: this order table screenshots

F column G column is we get the information, there are several lines of different orders, such as A 2.0670.004 from the inbound list match information

The following is the result of the match:


Code screenshots are as follows: the main is to use arrays and dictionaries, if you have better ideas, please correct me,


The attached excel file, don't know why I can't upload, post for the first time,
It was too cold, typing hand is cold, he said few detailed code is not complicated,