Exracting unique text from different cells

qexcel

New Member
Joined
Nov 23, 2005
Messages
1
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

:(
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

Assuming that the keywords are in the range G1:L1 then array enter (ctrl, shift, enter) the formula
Code:
=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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,611
Members
412,332
Latest member
hectamuptra
Top