Copy of snippet "Get Supplier From SKU"

=(INDEX(IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!J:J"),MATCH({formtext: name=Sku_Cell_Ref},IMPORTRANGE("1cEFCT_dr3cq-5HWdmr_2jZ6RxSYJ0P1cB0nHM_u73XE", "Sheet1!A:A"),0)))