SUHASA SHETTY
New Member
- Joined
- Apr 17, 2014
- Messages
- 10
Hi..
We can use INDIRECT function for dynamic selection of cell reference or named range or range linking to cell, it is not working for named formula.
Eg..
ABC, ACB, BAC are a named formulae..
The cell A3 is having dropdown list with texts "ABC","ACB","BAC".
My requirement is that B3 shall provide the result based on the selection from the dropdown list.
What formula i have to write in cell B3 to get the values i.e., =ABC or =ACB or =BAC.
Is there any solution in excel. Can INDIRECT function be used.
Thanks
Suhas
We can use INDIRECT function for dynamic selection of cell reference or named range or range linking to cell, it is not working for named formula.
Eg..
ABC, ACB, BAC are a named formulae..
The cell A3 is having dropdown list with texts "ABC","ACB","BAC".
My requirement is that B3 shall provide the result based on the selection from the dropdown list.
What formula i have to write in cell B3 to get the values i.e., =ABC or =ACB or =BAC.
Is there any solution in excel. Can INDIRECT function be used.
Thanks
Suhas