![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 7
|
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. |
|
|
|
|
|
#2 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,317
|
Quote:
|
|
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 7,743
|
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 |
|
|
|
|
|
#4 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,064
|
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!
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|