Im trying to find out if it's possible to populate a range based on a drop-down list choice you make.
Heres a small sample of what im working with for visual aid.
Spread Sheet Sample
As you can see plans and titles, drop down selection, and 6 plans I intend to refrence one at a time through the drop-down menu (I expect that these will end up on another sheet and hidden). Basically what I am trying to avoid is having to assign every single cell a VLOOKUP function and simply fill in the entire column entitled Aetna Plans instead.
Heres a small sample of what im working with for visual aid.
Spread Sheet Sample
As you can see plans and titles, drop down selection, and 6 plans I intend to refrence one at a time through the drop-down menu (I expect that these will end up on another sheet and hidden). Basically what I am trying to avoid is having to assign every single cell a VLOOKUP function and simply fill in the entire column entitled Aetna Plans instead.