# Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.

## Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .

## Value Of Cell Based Adjacent Drop Down List Value

Apr 25, 2008

The easiest way for me to explain it is to give an example: if the list contains Red,Blue,Green,Yellow. i need a formula for the adjacent cell that inputs £1 if red is chosen, £2 if blue is chosen, £3 if green is chosen, £4 if yellow is chosen

## Display Data Based On Selected Month From Drop-down List?

May 14, 2014

I want a table to display data based on which month i select from a drop-down list, the data is of course extracted from a different table. For example, in my final table( highlighted in yellow), i want to display the revenues, cost of goods sold..etc of April in this table when i choose April from the drop-down list, the data of the entire year is located in another table that i plan to hide, as we only need to review one month.

## Drop Down List Values Dependant On Value Of Another Drop Down List

Dec 9, 2009

I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.

If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.

## Drop-Down List: Generate A List Based On The Value Of A Cell

Jan 7, 2009

I am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15
A drop-down list displays the values 1 through 15. Cell A1 changes to 20
Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.

## How To Return Corresponding Values Based On Drop-down List

Jun 3, 2014

I have created a drop down list of various material sizes what I am needing to do is to select a material size from the drop down list and a corresponding value is input into the cell. So on say sheet two (Data Sheet) I have Cell A1 25x25 with Cell B1 100, Cell A2 30x30 with Cell B2 120 and so on. On sheet 1 Cell A1 has my drop down list being the material size ie 25x25, so what I need to happen is if I select 25x25 then Cell B1 is 100 or if I select 30x30 then cell B1 is 120.

## How To Look Up Based On Two Values Generated From Drop Down List

May 10, 2009

Ok what I am trying to do is lookup a value in a table (kinda like one below but alot bigger). What I plan on doing is creating a drop down list for the rows that show "A, B, C etc) and then another drop down for (AA, BB, CC etc).

So lets say the 2 drop-down list are set to C and BB
I want to be able to fill another cell with the value -134

I would use If statements but like I said the table would be alot bigger than example. If possible I would rather not use VBA due to work security settings.

a b c
AA-110-110-129
BB-115-115-134
CC-117-133-136

## Drop Down List With Pre Selected Value

Aug 25, 2009

My requirement is to implement a drop down list having two values "Yes (Recommended), No", I want the value "Yes (Recommended)" to be default value for all cells on which this validation is put. But also need a message box to be displayed if the user go ahead and select "No" the message box should be like "If you are not certain about this feature please click on 'Cancel' and contact you List Provider." and have 'Ok' and 'Cancel' button on it.

## Create A Drop Down List Based On The Value In A Cell

Oct 14, 2008

I have ranges that are named Math, Reading, Science. I would like to create a drop down list in validation that chooses the range based on a value in a particular cell.

## Cell Contents Based On Drop Down List

Jan 6, 2006

Can the information in say cell b:1 be based on the information in A:1? Example: If A:1 has the name Fred Smith then I want cell B:1 to say Nurse. Column A will have a drop down list of names and column B will have a list of Nurse, EMT or Paramedic. When someone pick a name from the list the information in column B will automatically be filled in based on the information in column A.

## Drop Down List Based On Cell Content

Jul 22, 2007

I'm trying to find a macro that will allow me to enable several drop down lists in the same cell based on the content of another cell. In other words:

If cell A1 is the data entry cell, and the user enters "cat"
Then cell B1 will display a drop down list of previously grouped options: "mouse, bug, bird"

If in cell A1 the user enters "dog"
Then cell B1 will display a different list of previously grouped options: "mole, rabbit, kibble"

## Give A Valor To A Selected Number In A Drop Down List

May 25, 2007

when i selelct a number of a the dropdown list can i get it to show other number in the cell below? example if i select 7:00-15:00 from that list it would show 8:00 in the cell below..

## Populate A Cell Based On Input From A Drop Down List

Jan 19, 2009

Various Numbers Will Be in a drop-down List eg:
6718
0820
7141
0821

I need it to Be able to, When I Select '6718' from the drop down Menu
"375 CAN 2lB18 C/F D/COKE" will Appear in the Next Cell.

## Go To Cell Based On List Item Chosen From Drop-Down

May 7, 2008

I have a set of data on excel and would like to make searching for it easier.

I have created a drop down list in cell B4 (say, "Banana", "Apples" and "Orange"). Is there a way that if i select "Banana" in cell B4, excel will automatically go to cell A20 ?

## Return Value Based On Selection Chosen From Drop-down List In Cell Next To It

Jul 2, 2014

I need VBA code to do the following:

When cell H2 = "Weekly", I need cell I2 to return "50".
When cell H2 = "Bi-weekly", I need cell I2 to return "25".

The value in Column I should change as soon as the value in Column H changes.

NOTE: The value in Column H is chosen from a Data Validation List.

I'm assuming offset is the best option?

## Return Cell On Separate Sheet Based On Selection From Drop Down List?

Mar 18, 2014

I am trying to create individualized worksheets based off a master worksheet. I have different committee names that I want to appear on the individualized sheets, based on whether the person is apart of that committee or not. On my master sheet, I choose the persons name under the committee and I want that committee name to show on the individualized sheet. For example, I want A1 on Master to show on Name 1, B3 and A10 on Master to show on Name 1, C3. Can I write a formula to achieve this or or am I asking too much? In my actual file, I will have about 10 names and 5 committees with one person being on up to all 5 of the committees.

## Pre-determined Values In Drop-down List

Oct 5, 2009

I am trying to figure out how to build a drop-down menu with VBA that has 2 built in choices, 'call' or 'put', and based on the selection in the drop-down list (call or put), the value in the cell directly to its left will be 1 (if 'call' is selected) or 2 (if 'put' is selected).

I have tried doing this with the data validation tool, but the problem I have run into is that I do not want to store the items in the drop-down list (call or put) anywhere in the excel sheet.

## Iterates Through All Of The Values In The Drop Down List

Dec 15, 2009

I have a sheet with a drop down list. When a user selects a value from the drop down list the sheets field's are populated. I would like to make a macro that iterates through all of the values in the drop down list and for each time it does this print the sheet. So will have the full sheet printed for each value in the drop down.

## Drop-Down List To Be Based On Choice Of Another

Apr 23, 2008

I have a drop-down box(K6) When a style is selected I need to have data show up in other drop-down boxes (H3,L3,P3) These selections would only pertain to the selection in K6. They would change when a different style is selected. There are multiple choices in the secondary drop-downs. [IMG][/IMG]

## Drop Down List Based On Choice From Another

May 1, 2008

What I need to do is create a Drop Down box. When a user makes their selection it gives another drop down box from what they selected. Each choice in the 1st drop down will give a different drop down box in the next field from what they selected in the 1st. I am having troubles getting this to work.

## Auto Sort Values In Drop Down List

Dec 12, 2009

i had a list based on dynamic formula.When ever i update(Add or Delete) New items to my List the drop down list should also be updated and sorted in Alphabetical order(Ascending :Words Starting with A - Z). How do i remove the blanks in the drop down list whenever i delete the data in the Source Data.

## Setting Default Values In A Drop Down List

Feb 14, 2007

I want to automatically set default values in a row dependant on the value chosen in a list. Some of the default values need to be lists where the user can chose to update to a non-default value.

I have tried using a double drop down list. However if the default list value is changed then the dependant list value is changed, the default list is not automatically updated.

## VBA - Add Number To Certain Cells Based On Drop List Value

Jun 30, 2014

I have a numerical value in cell B2 , and a drop list that contains unit names.

I am looking for VBA to see which unit is selected in the drop list, and then add B2's value to that particular unit's total.

## Formulas Based On Drop Down List Item

Nov 7, 2008

http://home.comcast.net/~unkerjay/CSBG_Sheet.xls

in it, there's a Sheet named:

CSBG Report

which has a drop down list for all possible reports
beginning with "Jan".

There's also a "Totals" sheet which has the corresponding
information for each report totaled in separate columns.

Jan, for instance is totaled in column B.
Feb, is totaled in column C.
And so on.

What I'd like to be able to do, is, depending on
the report selected, to have the information in
the corresponding cells in the "CSBG Reports" Sheet
pulled from the appropriate column in the "Totals" Sheet.

So far, I'm not wrapping my mind around a way to
do this.

## Message Box Code Based On Drop Down List

Nov 10, 2009

I have a dropdown list in my spreadsheet, on the list is Compound, Pay by Check, Internal Transfer, and ACH. I would like a message box to pop up with a message when anything except Compound is selected. The cell is d38.

## Drop Down List Based On The Result Of A Vlookup

Mar 5, 2010

I am trying to make a drop down list based on the result of a vlookup.

What i want to do is look into a table that has country name, depot station, but i have more than one depot per country so when i look up with vlookup i only get one result back, the table looks like this.

Country Country nameDepot code Depot name 1 GBUnited Kingdom STN Stansted 2 GBUnited Kingdom EDI Edinburgh 3 GB United Kingdom EMA East midlands 4 FR France
GNO Garanoa 5 FR France MRS Marseille

How can i look up GB or United Kingdom and get all the depots listed from that country.

## Conditional Drop Down Lists Based On Another List

Feb 17, 2006

Just wondering if a drop down list can be specific to a selection made in a previous cell. For example in column A the user would select either:

Weekly
Monthly
Other

Then in column B, the drop down list would be conditional upon what was selected in A. So if the user selected 'Weekly' - the drop down list in B would be: Monday, Tuesday, Wednesday, etc. Or if the user selected 'Monthly' in column A's list, the list in column B would be: 1, 2, 3, ......31.

## Drop-down List Based On Selection In Another Sheet

Dec 4, 2007

how to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box.

Example:
If Fat, Use range from C6:C7
If Skinny, Use range from D6:D7

Note: I tried putting an if statement in the input range for box2 but won't accept it.

## Create Drop Down Boxes Based On List

Jan 29, 2008

My problem is i need to create a drop down box in excell, now i have a list of names,

Name 1
Name 2
Name 3
Name 4..........

I need all thos enames in a drop down list but i think i keep doing things wrong, I am doing it like this,
All names are in cells A23-A33, i have highlighted them and named them (Names) using the name box in the top left corner, i have then gone to Data, Validation, List, Then i have sourced it to "Names" and clicked ok, this is where my problem is. It Makes all the boxes for Name 1 - Name 10 Drop Down Boxes... And when i click on any of them it gives me a list of all the names, when i click on one of the Names that name appears in the drop down box but the original Name dissapears from the box completely!

Name 1
Name 2
Name 3
Name 4
Name 5..................