Adding to this I have extended the formula to include the characters I want however there is a list with cells that may contain these characters and I want this list to be ignored.

Is there a way of adapting this formula to not include strings of characters in the specified cells.

=IF(SUM(COUNTIFS(A4,{"*DK*","*TK*","*TJ*","*BJ*","*DJ*"})),"Knitted",IF(SUM(COUNTIFS(A4,{"*DW*","*TW*","*BW*","*SW*","*DD*","*DP*","*DL*","*TD*","*BD*","*BP*","*BL*","*SL*","*SD*","*DM*","*DD*","*TD*"})),"Woven",""))

I have included an example. Sheet 1 contains the formula sheet 2 includes the cells highlighted in red that I want to ignore. For example one of these cells contains 'RDWE01' so in this instance where DW has been used in this string it would be ignored.

Hope that makes sense, thanks in advance.

JakeExample.xlsx