#### RandomizerTX

##### New Member

- Joined
- Jul 4, 2014

- Messages
- 33

Hello everyone:

Column A contains numeric values. I need Cells in Column B to have a dropdown validation lists that allow selection of the positive or negative of the value in the adjacent Cell in Column A. So for example, if $A$1 contains 445, then the dropdown list for $B$1 should offer the options of 445 and -445.

Can I generate these pairs of choices without VBA and without having to store the two values elsewhere in the worksheet?

Thanks in advance.

Column A contains numeric values. I need Cells in Column B to have a dropdown validation lists that allow selection of the positive or negative of the value in the adjacent Cell in Column A. So for example, if $A$1 contains 445, then the dropdown list for $B$1 should offer the options of 445 and -445.

Can I generate these pairs of choices without VBA and without having to store the two values elsewhere in the worksheet?

Thanks in advance.

Last edited: