How to change word in cell using another word in another cell [Solved/Closed]
1) You can use the IF command like this:
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:
Assuming the list is in column E and Group name is in column F