Drop-down Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Dependent drop down dynamic range formula, off sheet. 7
How to find a value with multi-column, multi-record list 1
Drop Down with dynamic named range offsheet source list 14
Excel Excel: How do I put a formula in a drop down list 11
Drop Down List Question 5
Using drop-down lists 4
DATA VALIDATION/DROP DOWN LIST 1

Back
Top