Drop Down Box

[Steve]

Is there a way to make multiple cells fill in based on a selection in a drop
down box?

[Dave Peterson]

Maybe creating a table that has the values in the leftmost column and the values
to be retrieved in the 2nd through nth column.

Then you could use =vlookup()

=if(a1="","",vlookup(a1,sheet2!a:e,2,false))

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html

Steve wrote:
>
> Is there a way to make multiple cells fill in based on a selection in a drop
> down box?

--

Dave Peterson