Text match and text update formula.

[Andy308]

The formula to match the text from list sheet with B and C Column of data sheet and in F column it should through up result if match found.
if no matching text found then, just update as " no match"
List sheet there will be additional line added daily.

Thanks in advance.

[63falcondude]

Convert your range in List into a table, then use this in F2:

=IFERROR(INDEX(List!A:A,AGGREGATE(15,6,ROW(Table1[List])/ISNUMBER(SEARCH(Table1[List],Data!B2:C2)),1)),"no match")

See attachment.