drop down lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rockon - 18 Oct 2004 02:37 GMT

i am trying to make an invoice list. i would like it when i type in a product
or get it from a drop down list for the price of that particular item to show
in the collumn next to it.

Signature

thanks so much

Reply to this Message

Debra Dalgleish - 18 Oct 2004 02:41 GMT

You can use the VLookup function to return the price. There are
instructions in Excel's Help, and here:

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

> i am trying to make an invoice list. i would like it when i type in a product
> or get it from a drop down list for the price of that particular item to show
> in the collumn next to it.

Signature

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

Reply to this Message

BenjieLop - 18 Oct 2004 23:51 GMT

You should probably have this set up:

Column X will contain the product name AND
Column Y will contain the product's corresponding price

Assuming that the product name will be entered in Cell A1, enter th
following formula in Cell B1:

=vlookup(A1,$X$1:$Y$100,2,0)

NOTE: Another assumption in the formula is that you only have 10
products hence 100 prices, as well. You can adjust the range in you
VLOOKUP formula as required in your application.

rockon Wrote:

> i am trying to make an invoice list. i would like it when i type in
> product
[quoted text clipped - 3 lines]
> --
> thanks so muc

--
BenjieLo

Reply to this Message