The function of two or more Excel that can be extracted?

It is assumed that there are the following two tables.
【A file 】
Cell..commodity.Classification?11 the second line of names 21 12 ABC 3 line 22 13 DEF 4 line 23 GHI
【B file 】
Cell..commodity.Classification?1 the second amount of money of name code line It encounters and two floats 11000 100 11 the third line It is 21 or 55000 effective 200 3 the fourth line Four is pierced and become empty 90000 300.
Commodity of “A file”?+ classification?Do it retrieve from “B file” corresponding data, do it exist in another file of the each line, and extracted function has saying!
I would like you to teach if there is a method of the plural extraction because it thinks the agreement for two or more lines to exist.
The question assumes that it is.
Please refer to the following functions though it is thought it is complex for a moment.
1.The seat seat name “Search condition” is made for another file.
2.A2 cell of seat “Search condition”:”【B file = 】 Sheet1 $A$2″
The B2 cell: “【B file = 】 Sheet1 $B$2. ” C2 cell: “【B file = 】 Sheet1 $C$2. ” D2 cell: “【B file = 】 Sheet1 $D$2. ” E2 cell: It is input, “【B file = 】 Sheet1 $E$2″. Please copy the function only onto F･G･H････ and a necessary amount similarly about this about the following of E2.
“Commodity No”, “Classification No”, “Brand name”, “Code”, “Amount of money”, and the name are put from the left side in the 3.1th line.
4.Please move to the seat with the data of the extraction origin, and input to the place of the first line of “Commodity?”, “= DGET (【B file 】 Sheet1 $A$1:$E$***, “Commodity No”, and search condition A1:C2)”. “***” here becomes the number of the final line specified by “2″.
5.Next, the first line of “Classification?”:”= DGET (【B file 】 Sheet1 $A$1:$E$***, “Classification No”, and search condition A1:C2)”
Brand name..file..classification..search condition..code..file..amount of money..file..input.
It refers because it is thought it is safe in this.