Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|