| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking other cells to a list item
I have tried a number of things and searched all over but can't figure out
how I can link other cells to a list item. Example - if I select a specific item from the drop down list I want to be able to get the price for the item as well from my price list, which could be in the same worksheet or workbook. Just trying to built a simple calculator for material used. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking other cells to a list item
Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:
http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Francois" wrote: I have tried a number of things and searched all over but can't figure out how I can link other cells to a list item. Example - if I select a specific item from the drop down list I want to be able to get the price for the item as well from my price list, which could be in the same worksheet or workbook. Just trying to built a simple calculator for material used. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel List functions and linking cells | Excel Discussion (Misc queries) | |||
| I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) | |||
| Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions | |||
Linear Mode
