Advanced Search in Column
There is an Excel file that teaches how to perform the Advanced Search in Column operation.
Excel Professional Advanced Search in Column
This workbook demonstrates advanced search in column using VBA macros on a 1-row data layout.
Hope it is useful.