Searching Table In Bulk
There is an Excel file that teaches how to perform the Searching Table In Bulk operation.
Excel Powered Searching Table in Bulk
This workbook demonstrates searching table in bulk using VBA macros on a 19-row data layout.
Hope it is useful.