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

Excel 2010
	R	S	T
3	A1	A1	A1
4	A2	C4
5	A3	B3	B3
6	A4
7	B1
8	B2
9	B3
PowerRatings

 

[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