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

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.

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

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


On Wed, 14 Dec 2005 14:43:13 -0800, notnuffun
wrote:

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.

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

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

"Gord Dibben" wrote:

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


On Wed, 14 Dec 2005 14:43:13 -0800, notnuffun
wrote:

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.

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

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

On Thu, 15 Dec 2005 06:22:02 -0800, notnuffun
wrote:

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

"Gord Dibben" wrote:

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


On Wed, 14 Dec 2005 14:43:13 -0800, notnuffun
wrote:

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.