| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I reference multiple rows
I need to create a list and reference multiple cells to a row or column in
that list, preferably using a pick list. More specifically, I have an invoice and I want to select a specific product and have the data for that product reference the cells following. Item Description Price Dropdown Reference previous selection Reference following I want this to be done with excel, please help! Mark |
|
#2
|
|||
|
|||
|
Mark
See Debra Dalgleish's site for using VLOOKUP with Data Validation drop-down pick lists. DV basics.. http://www.contextures.on.ca/xlDataVal01.html VLOOKUP basics.. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben Excel MVP On Wed, 3 Nov 2004 10:40:02 -0800, "Awetronics" wrote: I need to create a list and reference multiple cells to a row or column in that list, preferably using a pick list. More specifically, I have an invoice and I want to select a specific product and have the data for that product reference the cells following. Item Description Price Dropdown Reference previous selection Reference following I want this to be done with excel, please help! Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| how do I insert multiple rows in excel after every row of data | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| How do I use conditional formatting for multiple rows? | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
