Identify a test word in a column

rwmill9716

Active Member
Joined
May 20, 2006
Messages
432
I have a list of text symbols in Col R that can be several hundred long. I have another list in Col S, and I want to know if members of my list in Col S are members in Col R. If they are, I write the identifier in Col T. If not, I leave the appropriate cell in Col T blank. I need a function in Col T that will do that for me.

Thanks for your help.

ric


<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>R</th><th>S</th><th>T</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">A1</td><td style=";">A1</td><td style=";">A1</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">A2</td><td style=";">C4</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">A3</td><td style=";">B3</td><td style=";">B3</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">A4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">B1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">B2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">B3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:7.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">PowerRatings</p><br /><br />
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

ukmikeb

Well-known Member
Joined
Jul 10, 2009
Messages
2,757
Hi

Try in T3 :-
Code:
=IF(ISNUMBER(MATCH($S3,$R$3:$R$9,0)),$S3,"")
and drag down, adjust cell references for column R as required.

hth
 

Watch MrExcel Video

Forum statistics

Threads
1,109,331
Messages
5,528,052
Members
409,800
Latest member
camronmartin

This Week's Hot Topics

Top