a function question

  • Thread starter Thread starter kwongwa
  • Start date Start date
K

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
 
Assumptions:

1. Your "another chart in the same file" is in the range -- M1:P100

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.
 
Back
Top