roc_on_the_rocks
Board Regular
- Joined
- Jun 6, 2009
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
Hi folks, I'd really appreciate some guidance, this is driving me nuts (and it's work related).
Let's say I have a range of values named 'apple', another named 'banana', and another named 'orange' (all w/o the quotation marks).
Then there's a cell where the user will select the fruit of choice (I'm facilitating that choice by using Data Validation drop-down listing the fruits).
Then a formula will read from that cell which named range is to be used in the calculation. I got it to work once, than it doesn't work anymore, even in new files.
I'm obviously paraphrasing my problem, but this should get me going.
BIG THANKS in advance.
Let's say I have a range of values named 'apple', another named 'banana', and another named 'orange' (all w/o the quotation marks).
Then there's a cell where the user will select the fruit of choice (I'm facilitating that choice by using Data Validation drop-down listing the fruits).
Then a formula will read from that cell which named range is to be used in the calculation. I got it to work once, than it doesn't work anymore, even in new files.
I'm obviously paraphrasing my problem, but this should get me going.
BIG THANKS in advance.