Index match function without array formula for multiple rows.

Hi and welcome to the forum!

Are you able to upload a sample workbook to illustrate your query? If not, perhaps a reduced, mocked-up version which at least exhibits the same issue.

Regards