Copy of Snippet "Get Sku From Cat"

Snippet Exchange
1

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