IF cell contains text found in another column

[OllyMUK]

Hi

Can someone help me with this query? I need to highlight all the lines in the first table where column B has text that matches Column B of the second table.

I have a table of hardware like this;

I have another table like this

I want to create a column in the first table to show YES/NO as to whether the numerical code in column B contains any string that matches any cell in column B of the second table.

I would use VLOOKUP to find other cells in the second table but I need a true/false return for the new column in table 1.

Does that make sense?

Olly

 

[hagia_sofia]

Hello, maybe something like this?

=LET(
table_1,B2,
table_2,$B$7:$B$8,
b,--(TEXTSPLIT(table_1," ")),
c,ISNUMBER(b),
IF(SUM((FILTER(b,c=TRUE)=table_2)+0)>0,"YES","NO"))

 

[kvsrinivasamurthy]

Select A2:C4( change as required). Table 2 is in Sheet2.
Apply CF
Formula

=COUNTIF(Sheet2!$B$2:$B$10,$C2)>0

or

=ISNUMBER(MATCH($C2,Sheet2!$B$2:$B$10,0))