rwmill9716
Active Member
- Joined
- May 20, 2006
- Messages
- 448
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
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 |