Searching with Index Function
There is an Excel file that teaches how to perform the Searching with Index Function operation.
Excel Format: Searching with Index Function
This workbook uses INDEX function with VBA to look up values in a 37-row monthly data table spanning January through April columns.
Hope it is useful.