Issue With Lookup 255 Character Limit

Apart from that i think it's working 100% :D

obviously not 100%

Do you mean the formula in Data sheet give the errors? That end up transcribing to column S?

Try adding the Error trap from before

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",LOOKUP(2,1/(ISNUMBER(MATCH("*"&A$2:A$4&"*",LEFT(AWorkbookin!$A2:$O2,255),0))+ISNUMBER(MATCH("*"&A$2:A$4&"*",RIGHT(AWorkbookin!$A2:$O2,LEN(AWorkbookin!$A2:$O2)-255),0))),B$2:B$4)))

CSE Confirmed!