# Formula Based On Value Returned From Dropdown List?

Jan 21, 2014

I want to perform a calculation that is based upon user selection from a drop down list. In a simple for instance it would be something like:

Cell A1 has a drop down list containing 'Apples' & 'Oranges'

Cell A3 needs to have a formula that calculates the price based on the user selection from A1 with each option having different prices (prices set and do not require manual input)

Would an 'If' statement cover this and, if so, what would it be?

## Formula To Get An Average Based On A Dropdown List

Jul 14, 2009

Im creating a spreadsheet at work, which has a drop down box with the options of open and closed in it.

I also have a column for length of time of the claim, what i need to do, is now find a way of getting a average length of a claim, but only to see the closed option from the drop down box.

for example,

row 1
open date - 02/06, closed date - 01/07, dropdown box - closed, life - 29
row 2
open date - 10/06, closed date - n/a, dropdown box - open, life - -39400

as you can see from the example above, i cant simply do a average of the whole column, as would read the open ones as well. so is there a way of doing the formula, but telling it to only see the open, or closed ones?

## Formula To Find Two Cells Based On Dropdown List And Then Workout Difference?

Jun 5, 2014

I have a list of Names that has numbers accumulated over months. I am looking for a formula to use in a search tool that uses a drop down list to identify the name I am looking for and then the formula will show me the increase that happened in certain months.

See the attachment the result is coming from Denominators tab, I want the answer displayed in the Display tab, you will see a drop down list at C3 in Display, I am trying to show the answer in cell D9-I9.

how many the denominator has increased in that month. so for D9 it will come from denominator tab column c minus b, E9 will be d minus c

## Dropdown List Based On List In Another Cell Using Indirect?

Jan 29, 2013

I have 3 related dropdown lists that work perfectly, if you enter data from left to right. But, if you click in the cell containing the second list, which is based on the first list, of which nothing has been selected, you can just type any value in the cell. Is there a way to prevent this, or at least validate that what is entered is a value in the list.

## Dropdown List Based On Other Cells Value

Jun 26, 2014

Column C and D are should be picked from a dropdown list (data is in named range on sheet 3).

The choices that have t become available in a dropdown list in column E (values also in named rnage on sheet 3) should be based on the combination of column C and D.

The choices that have t become available in a dropdown list in column H (values also in named rnage on sheet 3) should be based on the value of column C.

I'm not sure the way it is set up now (as far as it is setup) is the way to go.

Here is a link to the file : [URL] ...........

## Dropdown List Based On Two Criteria?

Jul 9, 2011

I am trying to create a drop down list that is dependent on two criteria. To depict the issue, I've created a mock-example about sports.

On my 'data' sheet:
Column 1: Name of sport
Column 2: City
Column 3: Name of sporting team
On my 'form' sheet:
Cell 1: Dropdown list to select name of sport
Cell 2: Dropdown list to select city
Cell 3: I want this cell to be a dropdown list of names of sporting teams, based on the conditions set by Cell 1 & 2.

Example is attached.

## Macro Based On Dropdown List

Jun 24, 2009

I am trying to improve a process for someone in my workgroup to save a lot of time when reporting performance.

I have a spreadsheet with a drop down list of names. When I select a name from the drop down list I would like to copy a range of values on another sheet and paste special value a few columns over on the same sheet. I would like to have this only happen for the range of vaules on the row that correspondes with the name that I selected from the drop down list on the original sheet.

## Dropdown List Based On Criteria

Nov 27, 2009

customerdb.xls

Column A Column B
Customer ID Suppliers
0023 ABC Co.
0046 XYZ Co.
0023 qqq Co.
0034 MNO Co.
0023 ppp Co.

in another sheet in cell B2 user enters customer code(say 0023).

in cell C2 user is required to enter a single supplier of that customer(0023) from a dropdown list(source customerdb.xls). usually the dropdown list of C2 will show all the suppliers name where i need to show only 0023's suppliers in the dropdown.

so what i need is to filter C2's dropdown list based on customer id entered in cell B2.

## Cell Value Is Dropdown List Based On Other Cell Value Which Is Also Dropdown List?

Aug 4, 2013

fill the column "Level 2 Area" based on the value selected from "Level 1 Area" which is coming from a drop down list. So the "Level 2 Area" will be a drop down list also based on the selected value from the drop down list from "Level 1 Area".

Level 1 Area
Level 2 Area

## Retrieving Cells Based On Dropdown List?

Jan 13, 2014

I want to be able to pick a word from a drop down list and for related information to appear in the next cell. I just don't know the function to do it.

Here's an example: I have a list of first names and second names in adjacent columns.
Excel question 1.jpg

In the 2nd sheet I have a drop down list of the first names:

Excel question 2.jpg

Is there a function to make the corresponding 2nd name appear in B1 when a first name is selected. I've seen examples where INDIRECT is used to create a dependent drop down list in B1 but I'd like the information to automatically appear.

## GoTo Another Range Based On Value From Dropdown List

Jun 6, 2014

Based on the value (month) picked from a dropdown list, I want to go to the specific range of that month in the same worksheet.

Attached you can find a sample sheet. Map1.xlsx

## Copy Row Based On Dropdown List Selected?

Jun 10, 2014

I am trying to copy/extract row of data from worksheet(Detail)A:W to worksheet(1st Letter) if X=1st Letter on worksheet(Detail). I have never used VBA and i am not sure if this can be done with a formula.

## Auto Dropdown List Based On A Range?

Apr 30, 2014

Say columm Ahas values like:

A1
A2
A3
A3
A1
A2
G5
G5
101
5000
4574
5

Is it possible to have this columm filtered to return a dropdown list say in Cell B1 to show only unique numbers? In the case above would return;

A1
A2
A3
G5
101
5000
4574
5

Almost as in data validation "List".

## Dropdown List Range Based On Two Different Cell Values

Aug 2, 2012

I'm new to excel and was trying to make a workbook that will have a drop down list populate based on a user input in two separate cells. Basically, i have columns: name, pages, and books. I would like to have the drop down list match data by first finding the amount of books read, then finding the amount of pages read. Then any name that meets the criteria will be available in the drop down list. How can I do this?

## Getting Function That Will Return Numerical Value Based On Dropdown List

Aug 3, 2014

What I am trying to do is have a drop down list in one cell and have the next cell bring in the correct price for the item in the first cell. Sounds fairly easy? Well both lists are 200 items.

I have been trying to do this with just three items so far. On sheet two, I have created two lists. The first list in column A contains dogs, cats, mice. The second list in column B contains 1, 2, 3. On sheet one, I have created the drop down list for the animals in the A12 cell. I would like for B12 to auto populate the corresponding number to the animal without having to create an if formula for each animal and number.

## Creating SUM In Table Based On 2 Selections From Dropdown List

Aug 19, 2014

I'm creating a new spreadsheet for different fines we have as a football club.

I have a table frozen at the top which looks like this:

Fine 1 Fine 2 Fine 3
Player 1
Player 2
Player 3

Then also I have a list below this with the date and specific fines:

Date Player Fine Amount
(drop down (drop down Entered manually
list of players) list of fines)

I am wanting the amount of the fine to be entered into the table at the top of the spreadsheet automatically based on the 2 drop down list entries. I would also need the table to keep adding the fines together once new entries are made.

## Charting Data Based On Dropdown List Choice?

May 28, 2011

Charting Data Based On Drop Down List Choice

I am trying to build a report where I can chart data base on a dropdown selection.I did build the dropdown lists, however I don't have any expertise on execel functions in order to make it work.I am attaching my draft report.

## Dynamic Dropdown List Based On Column Filter?

Jun 9, 2014

I have a spread sheet that has three sheets, PROJECTS - TIMES - LISTS Time sheet.xlsx PROJECTS contains a list of 'In Progress' and 'completed' projects for work, with relevant other data, I.e. PROJECT No. / STATUS etc This will grow to 1,000's of rows TIMES will contain the amount of time a person spends on a PROJECT on a daily basis. This will grow to 10,000's of rows LISTS contain basic validation list for the first 2 sheets.

Part A
I would like to have a validation drop down list for the PROJECT NO column in the TIMES sheet that only lists the PROJECT NO from the PROJECTS sheet where STATUS <> COMPLETED. I.e. I only want to display the PROJECT NO's for current projects.

Part B
Even though I only want the PROJECT NO used, can the drop down list also contain other column's data for reference information only before one is selected.

## Nested If And Offset Formula From Dropdown List?

Apr 7, 2014

I have two lists ("fulllist" & "code" - A1:A20 is a data validated dropdown list of "fulllist". I want B2:B20 to return a list item offset one column to the item selected in A1:20

So, if A:1 drop down equals "asphalt paving" I want B:2 to insert a code from a list on cell right of asphalt paving.

Something like =IF(B31<>"fulllist",=OFFSET("fulllist",0,1,,),"") This returns an error. I have a feeling I need to use match. I can't seem to find an answer to this and I bet it is fairly simple.

## Automatically Color Worksheet Tab Based On Dropdown List Selection

Nov 21, 2012

I am new to VB macros, I am trying to figure out how to color a tab Green based on a selection from a drop down list.

## Update Certain Rows Based On The Choice Selected From A Dropdown List

Jan 11, 2010

Is it possible to update certain rows only based on the choice selected from a dropdown list

I shall explain this scenario

I have attached a small excel sheet called TESTTHEM which i'm testing
and learning excel simultaneously. On the attached sheet

If i select a value in B4 as BusinessLogic, it should then lookup for relevent rows in MISC worksheet and copy C5:L5 from MISC worksheet and replace
the columns G4:P4

Is it possible to do this in excel?

## Lookup / Dropdown List Based On Information Retrieved In Certain Field

May 22, 2012

I have a drop down (look up list) labeled Equipment that retrieves information from another sheet in my workbook.

I have a second field labeled Equipment Sub Type where I need a drop down list based on the information retrieved in the Equipment Field.

Each item in the Equipment List Drop Down has a corresponding list in my lookup sheet of my workbook.

## Autofilter Data Based On Cell Value (dropdown List) In Different Worksheet?

Apr 5, 2013

I've created drop-down lists in cells B3 and B4 (this is in worksheet 1), based on a column in Worksheet 2. I'd like Worksheet 2 to autofilter the data based on the drop-downs in B3 or B4, or both together.

## Cells Completed Automatically Based On Selection From Dropdown List

Jun 14, 2014

I need to make a dropdown list (I know how to do that) and based on that selection, I need some cells below to automatically complete. How can I do that? Is it possible with or without VBA?

## Hide/unhide Columns Based On Dropdown List Answer

Sep 26, 2008

I am a newbie to Excel. I really appreciate if someone could help me here and this is very urgent as I have a project going on.

I have a cell say B3, which is a dropdown list I created using Data Validation. It only lists down Yes or No.

What I need is when you click on Yes in B3, i need columns C to I to unhide. If answer is No, column C to I should be hidden. By default, the columns will be hidden.

Can you please help? I tried many times but not successful. Appreciate if someone will be able to walk me through details. If you want to see the sample spreadsheet, I can sent it to you by email. I tried Data> Outline group but they are not happy with this.

## Match Formula To Item Picked From Dropdown List?

Aug 7, 2014

I have created a drop down list for items we quote on. each item has a different formula depending on the variables on sheet one Sheet1. I have listed the formulas in the column next to the drop down list for each item, but our now need the main quote to put in the formula in another cell when the item is chosen from the drop down list.

## Excel 2007 :: Populate Another Cell Based On Selection In Dropdown List

Mar 7, 2013

[URL]....When I select a name in column B, it populates column C's dropdown with that name's list of units. When I select a unity type in column C, I'd like it to automatically populate column E in the same row with the value associated with that unit. The values associated with a particular unit can be found to the right of the sheet. So if in row 2 I select Blake in column B, then Unit 5 in column C, I'd like column E to be populated with 14.

Edit: using Excel 2007.

I attached stripped down version of the sheet which is small enough to post. None of the things I removed should affect the topic at hand. The full sheet is available at rapidshare.

## Automatically Select Item From Dropdown List Based On Cell Text

Apr 8, 2013

I have a spreadsheet where user can search for information inside a search box and the appropriate rows are returned using formulas.

I have a drop down list (Category: Model) in the search box as well as a search field (Category: Program, cell D2). Underneath the search box, search rows are returned with column categories: Program, Model, etc.

What I require is that if a user enters the specific program into the search field D2, then the dropdown list would automatically choose which model that program belongs to based on the returned row.

For example, if I typed "engine" into D2 and pressed enter,

Under the records section (Row 14 and beyond), the following record will pop up:

Program
Model
Indicators

Engine
F-16
3a

Based on the record, F-16 would be chosen from the dropdown list. Is there any way this can be done?

## Cross Reference (Vlookup) Based On Data Validation List Dropdown?

Jun 19, 2014

Attached is example of what I'm trying to do. I want to use the drop-down on the "Master Tab" and have the corresponding price by promo_month appear in the yellow cells.

Currently its on July, but I would like to switch that to August etc and have new prices populate in the yellow cells. Prices come from the "table" tab.

Example 06.19.14.xlsx‎

## Dropdown List Always Shows Unique Values From Column Based On Lookup Value

Jul 22, 2014

I have a worksheet (say, Sheet1) that I am going to manually import a large data set into on a weekly basis for reporting purposes. One of the columns from this data dump will have the header "Design Id" in the first row, but it may not be in the same column every time. I am trying to figure out how to create dropdown lists on a separate worksheet (say, Sheet2) in the same workbook where the data source always looks up the column containing the header "Design Id" from Sheet1 and then returns only the unique values from that column as options in the list.