It is also necessary to remove the surplus - from the names to get a correct match.... I removed it in the formula that I used: TRIM(SUBSTITUTE(A3,"-",""))

It will NOT work with Punto Cabernet Ibiza Merlot. I haven't tried it, but that should probably return Cabernet... Is that "split name" a common/predictable occurrence?