ENTER PRODUCT # AND HAVE assign DESC. & COST in invoice

[Guest]

I am making an invoice and wish to be able to put in a product code and from
that get a description and cost for invoice to calculate.

 

[Gord Dibben]

VLOOKUP table will look after this.

Table consists of 3 columns A, B, C on a separate Sheet2

Product code, description, cost.

Table is A1:C100

Need two formulas on your invoice sheet.

One in description cell(say E4), one in Cost cell(say E6)

E4 formula reads =VLOOKUP(E1,Sheet2!$A$1:$C$100,2,FALSE)

E6 formula reads =VLOOKUP(E1,Sheet2!$A$1:$C$100,3,FALSE)

Enter a product ID number in E1 and description and cost will be filled in.

You can use a Data Validation dropdown in D1 to enter the number if you wish.

Your ranges and cell references will most likely differ. Just make the
appropriate changes.


Gord Dibben Excel MVP

 

[Guest]

thank you I also need to insert a quanity and for it to do the multiplication

 

[Gord Dibben]

Enter a quantity in E7

In E8 enter this formula.

=E7*E6 will return quantity * cost

quantity = 12
cost(from vlookup) = 5.00 each

total = 12*5.00 = 60.00


Gord