vlookup + criteria

Hi there

thanks so much, that works awesome.

One final refinement and I am not sure how to add it. Rather, I tried but it was is not working.

There is another iteration of the way "PLT Coop" is written "2015 CO-OP PLT" and "2015 PLT CO OP ADVERT" -> is there a way to add in "Co-op" as well?

I tried to modify the formula

=IFERROR(IF(D6="","",IFERROR(IF(AND(SEARCH("*PLT*",J6),SEARCH("*COOP*",J6),SEARCH("*CO-OP*",J6))=TRUE,1,""),IF(AND(SEARCH("*PLT*",J6),SEARCH("*VB*",J6))=TRUE,2,""))),"")

^ see the part in bold, however it removes the 1 from lines where it shows "Coop"?

Any idea on how to include that?

Thanks a million!