drop down lists
 

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?

drop down lists
 

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)


--
Regards

Roger Govier


"Vivek" wrote in message
...
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?