Forum Discussion
Using the indirect formula in Names in data validation
Hi there, I'm trying to use Names in data validation. That works, but the Names are defined by the indirect formula. So there is 1 drop-down window in which several defined Names are presented,...
LennardW ,,,
INDIRECT considers TEXT value and tries to evaluate them as cell references.
=INDIRECT("A100") for A100.
INDIRECT converts the text "E1:E20" into the range E1:E20 with function.
=SUM(INDIRECT("E1:E20"))
With Named Range the formula should : =INDIRECT("Counrty")
Example above , the TEXT values is Country, INDIRECT converts it to cell references by matching existing Named Range.