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
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