Combing and ranking results

[managingcrap]

Guys,

Here's the function that I am looking for:

The function will automatically pulls information from the first table. When there are serial #s from the table 1 (attached sheet) that are the same exact, the result should show those two serial #s and respective Pet and Name. In addition, if the serial # in table 1 corresponds with the serial # in the table 2 (attached), then the serial number in table 2 will be pulled instead of that in the table 1.

If there are two the same serial #s in the table 2, the function will also include those information for that serial number (as shown in the left result). All other Serial #s (that is, serial #s that are not the same as those in table 1) from the table 2 will not be included

After that, the function should look into table 1 again and pull the serial and corresponding information. And the action is repeated until all information from table 1 (minus the exact same serial # b/w the tables 1 and 2) and the serial #s (exactly the same to those in table 1) are incorporated in the results table.