Using multiple drops
An Excel file that teaches how to perform Using multiple drops operation.
Excel Source: Using Multiple Drops
Data tables are defined in a sequential manner. The target value is searched for using a combined formula. Missing records are skipped during error checking. Results are compiled into a single table. The formula structure is organized in an explanatory manner.
Hope it is useful.