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

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

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.
 
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
 
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
 
Back
Top