Copy of Snippet "Get Title from Sku"

Snippet Exchange
1

=(INDEX(IMPORTRANGE("1atefmRid8ovNRzKJ-VQGInku6XolWA9o3aAxYK3_Mg4", "Sheet1!E:E"),MATCH({formtext: name=sku_cell_ref},IMPORTRANGE("1atefmRid8ovNRzKJ-VQGInku6XolWA9o3aAxYK3_Mg4", "Sheet1!A:A"),0)))