Drop down list
 

I understand how to create a dropdown list. What I'm seeking is to have excel
return a value depending on the selection made in the dropdown list.
Specifically a price depending on what item was chosen in the deopdown list.
Anyone know how to do this? - Thanks

Drop down list
 

Use VLOOKUP.

See example: http://cjoint.com/?dlnQZQpesD

HTH
--
AP

"scottyjr" a écrit dans le message de
...
I understand how to create a dropdown list. What I'm seeking is to have
excel
return a value depending on the selection made in the dropdown list.
Specifically a price depending on what item was chosen in the deopdown
list.
Anyone know how to do this? - Thanks

Drop down list
 

You can use a VLookup function to return the prices from a price list.
There are instructions in Excel's Help, and he

http://www.contextures.com/xlFunctions02.html

scottyjr wrote:
I understand how to create a dropdown list. What I'm seeking is to have excel
return a value depending on the selection made in the dropdown list.
Specifically a price depending on what item was chosen in the deopdown list.
Anyone know how to do this? - Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html