Invoicing Formula

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

Guest

Hi, Can anybody help me please? I am creating an Invoice in Excel but am
unsure of a formula to do the following, in product name column I have a
pull down menu of all my products, what I want to happen is that when you
select a product from the pull down menu the Product Description column and
Price column automatically fill in with the appropiate data, I have listed
all the data, product names, description and price in seperate columns to the
side of the invoice but I dont know how to realte the decription and price
and with the chosen product name.
Can anyone help me?
Many Thanks
(e-mail address removed)
 
You could start with this.

Labels in:
X1 = Name
Y1 = Desc.
Z1 = Price

Data in X2:Z20

A2 has drop down list.

In B2 enter:
=VLOOKUP(A2,$X$2:$Z$20,2,0)

In C2 enter:
=VLOOKUP(A2,$X$2:$Z$20,3,0)

Select B2 and C2, and copy down as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi, Can anybody help me please? I am creating an Invoice in Excel but am
unsure of a formula to do the following, in product name column I have a
pull down menu of all my products, what I want to happen is that when you
select a product from the pull down menu the Product Description column and
Price column automatically fill in with the appropiate data, I have listed
all the data, product names, description and price in seperate columns to
the
side of the invoice but I dont know how to realte the decription and price
and with the chosen product name.
Can anyone help me?
Many Thanks
(e-mail address removed)
 
Back
Top