Drop-down Lists
 

I am making a worksheet including the values "Name" and "Cost". I would like
to be able to select the "Name" in one column from a drop-down list and have
the "Cost" automatically be displayed in the column next to it. I know how
to make the drop-down list for the "Name" selection, but have not figured out
how to get it to add the "Cost" next to the name once it is picked. It will
not let me make a drop-down list with two columns and the cost needs to be in
a separate column in order for my fomulas to work :( If anyone has any
ideas how to do this, please let me know. Thanks!

Drop-down Lists
 

Build a simple lookup table somewhere in the sheet. Then next to the
cell with the drop down put a lookup formula such as =VLOOKUP(Name,
NameCost_Table, 2,FALSE).

That should get you started.

- John

Drop-down Lists
 

Build a simple lookup table somewhere in the sheet. Then next to the
cell with the drop down put a lookup formula such as =VLOOKUP(Name,
NameCost_Table, 2,FALSE).

That should get you started.

- John