How to change word in cell using another word in another cell [Solved/Closed]

Cherietan - Oct 1, 2015 at 03:27 AM - Latest reply: Cherietan 5 Posts Thursday October 1, 2015Registration date April 13, 2016 Last seen
- Apr 13, 2016 at 01:01 AM
Hello,

I have 2 qns

1) Everytime i enter "Sells" in a cell i want another cell to appear "to" and in the same cell if i key "Buys" i want the other cell to show "from"

2) I have a list of names that i have categorized into 3 groups.
1st group is "SEF"
2nd group is "NON SEF"
3rd group is "SEF AND NON SEF"

When i key in a name from the list into one cell i want another cell to appear if it is from the group "SEF" or "NON SEF" or "SEF AND NON SEF"


PLEASE HELP!!!!! IDK HOW TO GOOGLE THIS PROBLEM Have been trying but i dont understand.

thank you!!!


See more 

10 replies

Uzhavan 1 Posts Thursday October 1, 2015Registration date October 1, 2015 Last seen - Oct 1, 2015 at 04:44 AM
0
Thank you
Hi Cherietan,

1) You can use the IF command like this:
=IF(B2="Sells","to",IF(B2="Buys","from",""))

Assuming that cells in column B have the words sells or buys...you can paste this formula in column C.

2) Try to use lookup command:
=LOOKUP($H2,$E$2:$E$9,$F$2:$F$9)

Assuming the list is in column E and Group name is in column F
Cherietan 5 Posts Thursday October 1, 2015Registration date April 13, 2016 Last seen - Oct 7, 2015 at 08:14 PM
Hi i have another question... this one is more complicated. for example...

i have 10 names.

aa bb cc dd ee ff gg hh ii jj . aa bb cc are under the sef group.

dd ee ff are non sef.

gg hh ii jj are sef and non sef

When i key jj like what i followed ur previous instructions, it will come as sef and non sef. however i want to do an instruction

if i enter aa in one cell and bb in one cell , a third cell will come out as sef,

and if i key aa in one cell and gg in one cell, a third cell will still appear as sef. (because as long a name can do sef and non sef and if it meets a sef name, it has to be sef)

when i enter dd and gg i want the third cell to appear as non sef because gg can do sef and non sef.

sef names meets sef names = sef
sef names meets non sef names = error
sef names meets CERTAIN non sef & sef names = sef
non sef names meets CERTAIN non sef & sef = non sef



i wonder if u unds my qns

thanks!!
sohkyutebin 2 Posts Wednesday April 13, 2016Registration date April 13, 2016 Last seen > Cherietan 5 Posts Thursday October 1, 2015Registration date April 13, 2016 Last seen - Apr 13, 2016 at 12:29 AM
try using =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) first to return sef or non-sef, then =if() to return sef, error, non sef results.
Cherietan 5 Posts Thursday October 1, 2015Registration date April 13, 2016 Last seen > sohkyutebin 2 Posts Wednesday April 13, 2016Registration date April 13, 2016 Last seen - Apr 13, 2016 at 12:46 AM
lol thank u very much for your help sir you are too kind omg where do i find a kind soul like u
sohkyutebin 2 Posts Wednesday April 13, 2016Registration date April 13, 2016 Last seen - Apr 13, 2016 at 12:51 AM
I know right....
Cherietan 5 Posts Thursday October 1, 2015Registration date April 13, 2016 Last seen > sohkyutebin 2 Posts Wednesday April 13, 2016Registration date April 13, 2016 Last seen - Apr 13, 2016 at 01:01 AM
u definitely EXCEL in this particular set of skills...