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

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.
 
G

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top