crudepuddle
New Member
- Joined
- Jan 19, 2017
- Messages
- 16
I am trying to create a formula where if the user chooses a certain value, a different pre-defined value will appear in a separate box.
e.g.
If I select September as an entry from a validated list, then the box next to it will show me the target for September, which is saved in a different workbook.
Likewise if I select a Quarter (Oct, Nov, Dec) it will show me the relevant target for that quarter.
e.g.
If I select September as an entry from a validated list, then the box next to it will show me the target for September, which is saved in a different workbook.
Likewise if I select a Quarter (Oct, Nov, Dec) it will show me the relevant target for that quarter.
