Pulling the data for extracting the keyword

[pratheesh1983]

We have a set of key words and I'm looking for a formula which will the highlight (showing the keyword) if any of the key word is available in a text string on a cell.
eg. Table 1 have two columns - "Text" Column consists of multiple words & in column "Key Word Available" were we need to put a formula which will look for the Keywords mentioned in Table 2 in in column Text cells and will populate the keywords if it's available if not it will show the result as "N/A"

Could any one please help in formatting a formula here?

Table 1

Text	Key Word Available
Adjust audio settings according through lancable	audio; lancable
external monitor with a closedlaptop	monitor; laptop
How Do I Keep The Display On	N/A
This article will show you how to be able to keep using laptop or MacBook	article; laptop
You can now close your laptop lid	laptop

Table 2

Key Words

Audio

RAM

Lan Cable

Article

monitor

Laptop

 

[GraH]

Highly dependable on your version (you might want to update your account settings).

Book1
	B	C	D	E	F	G	H
2	Text	Key Word Available			Key Words
3	Adjust audio settings according through lancable	Audio, lancable			Audio
4	external monitor with a closedlaptop	monitor, Laptop			RAM
5	How Do I Keep The Display On				Lan cable
6	This article will show you how to be able to keep using laptop or MacBook	Article, Laptop			Article
7	You can now close your laptop lid	Laptop			monitor
8					Laptop
9					lancable
10
Sheet1

Cell Formulas
Range	Formula
C3:C7	C3	=LET( Keys,KeyWords[Key Words], rKeys,ROW(Keys), rHeader,ROW(KeyWords[[#Headers],[Key Words]]), Txt,B3:B7, BYROW(Txt,LAMBDA(t,TEXTJOIN(", ",TRUE,IFERROR(INDEX(Keys,AGGREGATE(15,6,(rKeys-rHeader)/(SEARCH(Keys,t))^0,SEQUENCE(COUNTA(Keys)))),"")))))
Dynamic array formulas.