Paparazzi Shopify Training - How to Upload Products in Bulk

Here is the formula to put in the TYPE column:
=ArrayFormula(iferror(ifs(left(F2:F,2)="P5","Earrings", left(F2:F,2)="P2","Necklace",left(F2:F,2)="P4","Ring",left(F2:F,2)="P9","Bracelet",left(F2:F,2)="P7","Hair Clip"),))