Dear all,

My Name is fazal, im trying to get a template for my office use, the thing
is i hv created a pricelist of parts in excel. thre are 20000 items in the
list. each part number has itw own item code. i created an invocing format
on the second sheet.( the column format is ITEM, DESC, PART NO, PRICE) wht i
neeed! when i put the part number on second sheet part no column the price
and description has to come automatically. plz sugst me a template or
function which i can use in Excel. i hp thr earliest rely from ur
side...................PLZZZZZZZ

Best regards
Fazal

Hi Fazal

Try VLOOKUP to insert the description and unit price, based on the part
number you have entered.

Obviously, your stock sheet should include these details as part of the
database. Not knowing how you have set this part up, it is a bit difficult
to write the formula for you.

If your part number is entered in say A10, you could use B10 for the Qty,
C10 for the description, D10 for Unit Cost and E10 for the Extende cost? Let
us also take it that your database is a range named Database, that part nrs
are in Col A, descriptions in Col B and cost in Col C

In C10 you could then use =VLOOKUP(A10,Database,2,FALSE). In D10 you could
use =VLOOKUP(A10,Database,3,FALSE)
In E10 you could use =IF(OR(A10="",B10=""),"",B10*D10)
If you copy these down as far as you want, you only have to insert the part
nr and qty.


--
ve_2nd_at. Randburg, Gauteng, South Africa


"Fazal" wrote:

Dear all,

My Name is fazal, im trying to get a template for my office use, the thing
is i hv created a pricelist of parts in excel. thre are 20000 items in the
list. each part number has itw own item code. i created an invocing format
on the second sheet.( the column format is ITEM, DESC, PART NO, PRICE) wht i
neeed! when i put the part number on second sheet part no column the price
and description has to come automatically. plz sugst me a template or
function which i can use in Excel. i hp thr earliest rely from ur
side...................PLZZZZZZZ

Best regards
Fazal