Forum Discussion
Cell Reference instead of Text
I am attempting to set up a Data Validation scenario which uses the INDIRECT function, but am having a bit of issue. I need the headers of the items in the "Create from Selection" to be CV8 and CV9,...
If you use INDIRECT(...) where ... evaluates to CV8, Excel will interpret it as the cell CV8, regardless of how you format ...
You might name the ranges CV8_ and CV9_
If your drop down listing CV8 and CV9 is in - for example - D2, the data validation formula could be
=INDIRECT(D2&"_")
That would allow you to keep on using CV8 and CV9, while avoiding the cell reference problem.