How do I populate multiple cells based on a List/Combobox

**SDennis** · 07-16-2008, 07:15 PM

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.

**Leith Ross** · 07-17-2008, 12:46 AM

Hello SDennis,

Welcome to the Forum!

The link you provided in your post is dead (error 404). Please correct this, so we can answer your questions.

Sincerely,
Leith Ross

**SDennis** · 07-20-2008, 11:54 PM

sry for broken link it should be working now, ive tried a couple of alternatives already searching forums and google for an answer to this problem.

Populating the list is no longer my issue, its having to assign the forumla to each cell which totals a couple thousand on my workbook.

**olasa** · 07-21-2008, 06:40 AM

I am not sure if this is what you are looking for (see encl.)
//Ola

**SDennis** · 07-21-2008, 03:59 PM

basically yes, in regards to my last question did you have to assign the HLOOKUP formula to each cell?? Because thats what im looking for now in the interest of saving time.