I am trying to create a function that will allow a user to select from a drop
down menu. Upon selecting an option, I want the other cells in this row to
automatically fill with the proper data. For example, if someone chose
English I, the room number and teacher name would automatically be filled in.
Can anyone point me in the right direction for this? Thanks.

VLOOKUP formula is one method.

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation selection lists for inputting
the selection.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP


On Sat, 19 Jul 2008 08:38:01 -0700, plaughermomma
wrote:

I am trying to create a function that will allow a user to select from a drop
down menu. Upon selecting an option, I want the other cells in this row to
automatically fill with the proper data. For example, if someone chose
English I, the room number and teacher name would automatically be filled in.
Can anyone point me in the right direction for this? Thanks.