IFERROR(...)

Category: Logical

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

IFERROR(value, value_if_error)

Category: Lookup and reference

Uses an index to choose a value from a reference or array

INDEX(array, row_num, [column_num])

Category: Statistical

Returns the k-th smallest value in a data set

SMALL(array, k)

Category: Logical

Specifies a logical test to perform

IF(Something is True, then do something, otherwise do something else)

Category: Lookup and reference

Returns a reference offset from a given reference

OFFSET(reference, rows, cols, [height], [width])

Category: Lookup and reference

Returns a reference indicated by a text value

INDIRECT(ref_text, [a1])

Category: Lookup and reference

Returns a reference as text to a single cell in a worksheet

ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Category: Lookup and reference

Looks up values in a reference or array

MATCH(lookup_value, lookup_array, [match_type])

Category: Lookup and reference

Returns the row number of a reference

ROW([reference])

0

This formula looks for the match of month and type, return the match, and the corresponding 8 rows downward. Then it looks if it has "y" in it and gives corresponding row number and this filtered using small function