Hi,
I'm trying to create a dynamic data validation list so it essentially works like a =Cell & "Drop Down List" formula.
Basically I'd like to put a currency symbol before the Units (blank, '000, m) which is a referenced table, it's sticking the currency at the front of the dropdown list that's the tricky part, the Excel table below gives you an idea of how it would ideally work.
Hope that's clear.
Thanks for reading, any suggestions welcome.
I'm trying to create a dynamic data validation list so it essentially works like a =Cell & "Drop Down List" formula.
Basically I'd like to put a currency symbol before the Units (blank, '000, m) which is a referenced table, it's sticking the currency at the front of the dropdown list that's the tricky part, the Excel table below gives you an idea of how it would ideally work.
Hope that's clear.
Thanks for reading, any suggestions welcome.
| Book2 | |||||
|---|---|---|---|---|---|
| E | F | G | |||
| 4 | Units | ||||
| 5 | £ | $ | € | ||
| 6 | £'000 | $'000 | €'000 | ||
| 7 | £m | $m | €m | ||
| 8 | |||||
| 9 | P&L 1 | ||||
| 10 | £ | £ | |||
| 11 | Unit Dropdown -> | £'000 | |||
| 12 | £m | ||||
| 13 | P&L 2 | ||||
| 14 | $ | $ | |||
| 15 | Unit Dropdown -> | $'000 | |||
| 16 | $m | ||||
| 17 | P&L 3 | ||||
| 18 | € | € | |||
| 19 | Unit Dropdown | €'000 | |||
| 20 | €m | ||||
Sheet1 | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| E6:G6,F19,F15,F11 | E6 | =E5&"'000" |
| E7:G7,F20,F16,F12 | E7 | =E5&"m" |
