drop down lists

V

Vivek

I haave a drop down list which is in a table. When I change the selection (on
the list) I want another cell in my "price column" to change value with it.
Is this possible?
 
R

Roger Govier

Hi

You could create a list with values relating to the items in your
dropdown list.
Set up on Sheet2 in cells A1:B100 a list with Item in A and price in B

Supposing your Column with the dropdown is Sheet 1 column A, and your
Price column is column C. In C1
=Vlookup(A1,Sheet2!$A$1:$B$100,2,0)
 

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

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Font drop-down menu very slow 0
MS Project Center-Autolink column fields 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Link a text box based on drop down box with four options MS Word 365 0

Top