That looks quite a complex way of doing an INDEX/MATCH.

It might help if you posted a sample workbook so that the formula can be seen in context.

Regards