a function question

[kwongwa]

I'm trying to build an invoice , it's form is like this:

item code description unit price

And I have another chart in the same file for references like this:

Item code Description unit price
001 Fish $????
002 Egg $????
003 Bread $????
.............

is there any function or mixture of functions I can use that if I punc
in the item code, the description and unit price of the row that cod
exists will come up automatically

 

[Don Guillett]

Have a look in HELP index for VLOOKUP

 

[BenjieLop]

Assumptions:

1. Your "another chart in the same file" is in the range -- M1100

2. You enter your "Item Code" in Column A starting at Cell A1

Do this:

Enter this formula in Cell B1 (to get the Description corresponding t
your Item Code in Cell A1):

=vlookup(A1,$M$1:$P$100,2,false)

and copy down to suit your needs

Enter this formula in Cell C1 (to get the Unit Price corresponding t
your Item Code in Cell A1)

=vlookup(A1,$M1:$P$100,3,false)

and copy down to suit your needs

Hope this helps you out.

 

[Frank Kabel]

In addition you may have a look at:
http://www.mvps.org/dmcritchie/excel/vlookup.htm