Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
notnuffun
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
notnuffun
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"