Forum Discussion
Solved
Populating an array from a list
The names on the far left are meant to be fixed in the first column. The second column has a drop down list of states, and I want an array to populate based off the selected state. The idea is that t...
Perhaps something like
=INDIRECT(SUBSTITUTE(B3," ","_"))
The defined names for multi-word states such as New Mexico should contain an underscore _ instead of a space.
Perhaps something like
=INDIRECT(SUBSTITUTE(B3," ","_"))
The defined names for multi-word states such as New Mexico should contain an underscore _ instead of a space.
