Automatically Fill in invoice

[trigger]

Hey all again!

I need help yet again. Once i have selceted a code number of an item from a drop down list i need the rest of the invoice (the price and what the item is called) to appear automatically, the pricec and item name is on the dsame sheet with the code number whereas the invoice is on a seperate sheet in the same workbook.

[Aladin Akyurek]

On 2002-04-23 09:46, trigger wrote:
Hey all again!

I need help yet again. Once i have selceted a code number of an item from a drop down list i need the rest of the invoice (the price and what the item is called) to appear automatically, the pricec and item name is on the dsame sheet with the code number whereas the invoice is on a seperate sheet in the same workbook.

Tyr using VLOOKUP.

[Brian from Maui]

Try VLOOKUP

Where column A is the code
Column B is the price
Column C is the name of the product
In the price portion of the invoice enter
=VLOOKUP(A1,range,2)
In the name of product
=VLOOKUP(A1,range,3)
A1 is the cell with the drop down list

[Jack in the UK]

Microsoft supply a really nice customable invoice calles INVOICE.XLS designed by village software, and add sheet to as the guys say VLOOKUP or = whatever you require...


easy cheat eh!