Hi,
Requesting help in excel. I have 2 cells with dropdown list of "up" and "down". I'm trying to
1) if cell 1 is "up" and cell 2 is "down", show "X" in cell 3.
2) if cell 1 is "down" and cell 2 is "up", show "Y" in cell 3.
3) if cell 1 is "up" and cell 2 is "up", "show "z" in cell 3.
4) if cell 1 is "down" and cell 2 is "down", show "z" in cell 3.
Thank you.