Help with numbers pop up menu
Good morning!
I am trying to do the following:
I have created a pop up menu in cell C1 with 3 options.
Is there a way to set some values in cells E1, E2 and E3 that will change aaccording to the selection in C1?
For example, if C1 is set to " New products ", I would like E1,E2 and E3 to show certain values while when choosing "Used products", the E1,E2 and E3 values will change accordingly.
Thank you!