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

- - Latest reply: Cherietan
Posts
5
Registration date
Thursday October 1, 2015
Last seen
April 13, 2016
- 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 

1 reply

Posts
1
Registration date
Thursday October 1, 2015
Last seen
October 1, 2015
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
Posts
5
Registration date
Thursday October 1, 2015
Last seen
April 13, 2016
-
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
Posts
2
Registration date
Wednesday April 13, 2016
Last seen
April 13, 2016
> Cherietan
Posts
5
Registration date
Thursday October 1, 2015
Last seen
April 13, 2016
-
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
Posts
5
Registration date
Thursday October 1, 2015
Last seen
April 13, 2016
> sohkyutebin
Posts
2
Registration date
Wednesday April 13, 2016
Last seen
April 13, 2016
-
lol thank u very much for your help sir you are too kind omg where do i find a kind soul like u
sohkyutebin
Posts
2
Registration date
Wednesday April 13, 2016
Last seen
April 13, 2016
-
I know right....
Cherietan
Posts
5
Registration date
Thursday October 1, 2015
Last seen
April 13, 2016
> sohkyutebin
Posts
2
Registration date
Wednesday April 13, 2016
Last seen
April 13, 2016
-
u definitely EXCEL in this particular set of skills...