Identify a test word in a column

[rwmill9716]

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

 

[ukmikeb]

Hi

Try in T3 :-

=IF(ISNUMBER(MATCH($S3,$R$3:$R$9,0)),$S3,"")

and drag down, adjust cell references for column R as required.

hth

 

[rwmill9716]

ukmikeb,

That function works great!

Thanks,

ric