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.