Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Im trying to figure out how to change the info in a few other cells when i
change a number in a drop list in Excel. |
#2
![]() |
|||
|
|||
![]()
Try something like this:
http://www.officearticles.com/tutori...soft_excel.htm Of course, you might not need all parts of it. :) ************ Anne Troy www.OfficeArticles.com "macbr549" wrote in message ... Im trying to figure out how to change the info in a few other cells when i change a number in a drop list in Excel. |
#3
![]() |
|||
|
|||
![]()
If you want to return information from a table, you can use the VLOOKUP
function. For example, select a product number from a dropdown list, and in adjacent cells, you can show the product name and price, from a product list. There's information on VLookup in Excel's Help, and he http://www.contextures.com/xlFunctions02.html macbr549 wrote: Im trying to figure out how to change the info in a few other cells when i change a number in a drop list in Excel. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to link cells and keep number format altogether | Excel Discussion (Misc queries) | |||
Return number of cells filled | New Users to Excel | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
How do I change the invoice number assigned in Invoice template... | Excel Discussion (Misc queries) | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) |