Copy of snippet "Get Cat from SKU"

=iferror(ARRAYFORMULA({(INDEX(IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!B:B"),MATCH(trim({formtext: name=Cat_Cell_Ref}),IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!A:A"),0))),(INDEX(IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!I:I"),MATCH(trim({formtext: name=Cat_Cell_Ref}),IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!A:A"),0)))}),ARRAYFORMULA({(INDEX(IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!B:B"),MATCH({formtext: name=Cat_Cell_Ref},IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!A:A"),0))),(INDEX(IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!I:I"),MATCH({formtext: name=Cat_Cell_Ref},IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!A:A"),0)))}))