software

I am making a worksheet including the values quot;Namequot; and quot;Costquot;. I would like
to be able to select the quot;Namequot; in one column from a drop-down list and have
the quot;Costquot; automatically be displayed in the column next to it. I know how
to make the drop-down list for the quot;Namequot; selection, but have not figured out
how to get it to add the quot;Costquot; 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!

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.

- JohnBuild 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