I am trying to get text to change in one column based on text selected from list in another;
example in D2 I have a drop down list representing the colour choices for a product that states
If the client chooses red, yellow or blue then it is include in the cost already and under the cost column in F2 should say Included, If the client chooses custom then I would like the cell in F to read Not Included? any tips or tricks?
Show text in one cell upon drop down list selection in another