I'm getting into Excel more and I am trying to do something:
I have a combo box in cell B2 with options of "1" and "2".
I have a combo box in cell B4 with options of "1" and "2".
(the selected value writes to the cell B2 and B4 under the combo boxes)
In cell B6, I would like to display a result where:
If B2=1 and B4=1, show "Hello"
If B2=1 and B4=2, show "Goodbye"
If B2=2 and B4=1, show "Go Away"
If B2=2 and B4=2, show "Thank You"
Is something like this possible? I have been trying to use an "IF(AND..." but I must be doing something wrong. Your help is appreciated.
Bookmarks