How to change word in cell using another word in another cell
Solved/Closed
Cherietan
-
Oct 1, 2015 at 03:27 AM
Cherietan Posts 5 Registration date Thursday October 1, 2015 Status Member Last seen April 13, 2016 - Apr 13, 2016 at 01:01 AM
Cherietan Posts 5 Registration date Thursday October 1, 2015 Status Member Last seen April 13, 2016 - Apr 13, 2016 at 01:01 AM
Related:
- Excel change word to another word
- Number to text in word - Guide
- Microsoft word free download - Download - Word processors
- Number to word in excel - Guide
- Word viewer - Download - Office suites
- Word to xps download - Download - Other
1 response
Uzhavan
Posts
1
Registration date
Thursday October 1, 2015
Status
Member
Last seen
October 1, 2015
Oct 1, 2015 at 04:44 AM
Oct 1, 2015 at 04:44 AM
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
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
Oct 1, 2015 at 08:03 PM
Do i have to add anything extra? Thanks for replying though!!! :)
Oct 1, 2015 at 08:37 PM
hmmm am i doing anything wrong
Oct 1, 2015 at 09:52 PM
Oct 1, 2015 at 10:18 PM
Oct 7, 2015 at 08:14 PM
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!!