Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
macbr549
 
Posts: n/a
Default change info in other cells when i change a number in a drop list?

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   Report Post  
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link cells and keep number format altogether Yi Excel Discussion (Misc queries) 0 May 6th 05 02:12 PM
Return number of cells filled LMB New Users to Excel 3 April 29th 05 02:55 AM
How do I change the category axis number formatting in a Pivot Ch. Cultcab Charts and Charting in Excel 0 April 19th 05 12:26 AM
How do I change the invoice number assigned in Invoice template... akress Excel Discussion (Misc queries) 1 February 28th 05 06:36 PM
how to change the state of a number in a cell from negative to po. Steve11 Excel Discussion (Misc queries) 1 November 29th 04 07:00 AM


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"