drop down lists

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

Guest

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?
 
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)
 
Back
Top