I have column A with 8000 text values (8000 rows) (e.g., RARUS03; RARUS43;etc.).
I have column C with 1500 text values (list of titles that may or may not include values equivalent to the text value in column A)(e.g., "Qualification of the RARUS03 Server", "Checklist for the RARUS43 Server").
What formula can I use for each of the 8000 text values in column A to check their presence as part of the text values listed in column C?
I have column C with 1500 text values (list of titles that may or may not include values equivalent to the text value in column A)(e.g., "Qualification of the RARUS03 Server", "Checklist for the RARUS43 Server").
What formula can I use for each of the 8000 text values in column A to check their presence as part of the text values listed in column C?