Exracting unique text from different cells

[qexcel]

Hello Iam not sure if there are any straight fwd way of doing this is in excel. Seeking the help of gurus for a response..

Here is the task I have. Iam trying to find if the Key words listed below in the Keywords Data header are present in the cells from A1...(These are descriptions) If I find any of the keywords anywhere from A1:A2, i want to add Y if not N

Keywords Data
Keywords: TWIN DCVD SACVD TEOS NEZ RPS
Available: Y Y Y N Y Y

A1 KIT, SIMPLE CATHODE, BASE, DCVD, 200MM, RPSGECO
A2 CONFIGURATION, SPARES, RPS GECO
A3 KIT SHIP, COMBO CHAMBER, TEOS LID CONVERTER
A4 KIT, RPS CHAMBER, UNRELEASED PARTS GECO A4
A5 R2-ESC,200,SIMCAT,CHEM 513,SUP,50/XT/52,ALL POS
A6 KIT LID COMMON 200MM TWIN CH PRODUCER

 

[acw]

Hi

Assuming that the keywords are in the range G1:L1 then array enter (ctrl, shift, enter) the formula

=IF(MAX(ISNUMBER(FIND(G$1,$A$1:$A$6,1))*1),"Y","N")

in G2 and copy to F2:L2

I get the results Y Y N Y N Y


Tony