Finding Table Conditionally
There is an Excel file that teaches how to perform the Finding Table Conditionally operation.
Excel Source: Finding Table Conditionally
This workbook demonstrates finding table conditionally using VBA macros on a 1-row data layout.
Hope it is useful.