|
|
|
|||||||
| 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 |
May 14th, 2002, 01:05 AM
|
#1 |
|
New Member
Join Date: May 2002
Posts: 9
|
hey list, here is what I am trying to do...
(problem is I don’t know what it is called) I know how to make a simple list pulldown via insert/name/define and then validation... what I want is to assign a list with a value for each name in the list, so when I pull down and select a name from my list excel automatically dumps the appropriate value for that selection into the next cell... I'm new at this and trying to pick it up pretty quick, I have a feeling this might be simple I just cant figure it out, thanks in advance... |
|
|
|
May 14th, 2002, 01:57 AM
|
#2 |
|
Board Regular
Join Date: Apr 2002
Location: Wivenhoe, England
Posts: 877
|
I'm not sure if this is what you want but you can name ranges with the list names and then use the INDIRECT function and Data Validation to vary the dropdown list. Thus if you name the ranges with country names, England, France, Spain, Australia etc and then put cities within the range, the selection of the Range name creates the appropriate list of cities in the next dropdown.
Juan Pablo G. did an article about it on this site a month or two back. I can't track it down at the moment. Can anyone else help? |
|
|
|
|
May 14th, 2002, 03:07 AM
|
#3 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
Are you talking about creating contants?
Name = Value ? Tom To further clarify... In a forms combobox, refer to a named constant and link to another cell for value placement... [ This Message was edited by: TsTom on 2002-05-14 02:14 ] |
|
|
|
|
May 14th, 2002, 03:27 AM
|
#4 |
|
Board Regular
Join Date: Apr 2002
Location: Wivenhoe, England
Posts: 877
|
Or do you need a VLOOKUP which looks for the item created by the dropdown?
|
|
|
|
|
May 14th, 2002, 07:53 AM
|
#5 |
|
New Member
Join Date: May 2002
Posts: 9
|
hey, thanks for all the replies...
(I'm still digesting it) allow me to clarify... I have a column of names, next to each name I have that persons hourly pay rate. I want to define this information as a list and have the ability to pull down the list info in other fields (using verify)... so in another part of the sheet I want to be able to use a list to select one of the names from a dropdown, once selected I want either that cell or the next cell to be made equal to the value associated... you all rock... |
|
|
|
|
May 14th, 2002, 02:34 PM
|
#6 |
|
Board Regular
Join Date: Apr 2002
Location: Wivenhoe, England
Posts: 877
|
Can you be more specific? Are you looking to call up a cell one cell to the right? If so an OFFSET formula could do the trick?
|
|
|
|
|
May 14th, 2002, 03:07 PM
|
#7 |
|
New Member
Join Date: May 2002
Posts: 9
|
hey...
imagine a list of names (validated pulldown type) taken from a list on another sheet... matthew = 30 rob = 40 toby = 50 now occasionally the values attached to each name change (and they are calculated)... so, you have a pulldown of the names, when you select matthew from the pulldown in a cell the cell next to is becomes 30, if you switch the cell plldown to rob the correct cell becomes 40... and again, thanks for suffering through this with me... |
|
|
|
|
May 14th, 2002, 03:26 PM
|
#8 |
|
Board Regular
Join Date: Apr 2002
Location: Wivenhoe, England
Posts: 877
|
A simple VLOOKUP should work.
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
