# Use VLOOKUP From Dropdown Menu Selection

Feb 27, 2007

I have a spreadsheet which is made up of 4 worksheets. I have a drop down menu on the front page (created with data validation). I want to be able to choose one of the 7 geographical areas from the drop down menu, then have a formula search through the other worksheets for rows of data with this geographical area in it. Any ideas on how to do this, I have tried with VLOOKUP but cannot get the formula to refer to the drop down menu for the first input, i.e. the geographical area that it should be looking to match.

May 1, 2013

How to create a dropdown menu to pick from two selections?

Basically, I have a 'Status' column and the status will always be 'Open' or 'Closed' and I'd like you just to be able to click a cell in that column and select one or the other.

## If Function To Test Dropdown Menu Selection?

Jun 11, 2014

I am developing a spreadsheet at work that is very similar to one that I made at a previous job. I am using the same formula in each spread sheet, but the one I am developing now does not work, where the previous one works perfectly.

I have a drop down menu created with data validation. Each possible selection is one or two letters of text, or the selection can be left blank. The drop down is cell A12, and an example of the if function that is used many times in this spreadsheet is as follows:

=IF(\$A\$12="L",1,0)

In the previous spreadsheet, the function returns true only when the appropriate selection is made. In the latest version, it will return true if the appropriate selection is made, or if drop down selection is blank. I have been able to work around this with the following:

=IF(\$A\$12="",0,IF(\$A\$12="L",1,0))

## Formula Based On Dropdown Menu Selection?

Feb 21, 2014

Sheet 1 has a table of prices. There are 7 columns labelled 2 thru 8 and two rows, labelled 1 and 2. Each combo has a separate price.

Sheet 2 has a weight specification (1 or 2 referring to the rows in sheet 1) and a drop down menu with options 2 thru 8.

When I choose a number from the drop down menu, let's say 5, I want to populate another cell with the value from sheet 1 of column 5 on row "whatever the weight spec is", let's say 2.

## Change Button Function Based On Dropdown Menu Selection?

Jun 9, 2014

I've got a drop-down menu with four options in it that match up with the cells D11:D14, and next to those I've got spots for counting the totals (E11:E14). Next to the drop-down I've got plus and minus buttons, and I need to make it so if I have the top option selected in the dropdown and press plus, it adds +1 to E11. Second option and the same plus button, +1 to E12, and so on.

The purpose is for a call tracker, the employee would select the reason for the call (maybe more added later) and hit the button to add the call to the report.

I've looked so I know you normally ask for what I've got so far, and that's nothing. I've got all the other buttons wired up but I don't even know where to start with this one. I can include a screenshot if necessary.

## Combine Rows With Similar Info In Dropdown Menu Or Selection For User

Nov 29, 2012

I have a spreadsheet that has a long list of charges... some of those charges have multiple codes attached to them... when this happens I am wanting to group them together and let the user pick which one they want to view at one time.

Here is a very small example of what exactly I am referring to... with charge #14 I am wanting it to combine and let the user pick between 2565 and 2566. The problem is that the values can range and will not always be 2565 & 2566 and there is 10,000 + records similar to this.

test.xlsx

## Dropdown VLookup Menu Returns Multiple Results?

Oct 11, 2011

I'm attempting something new, a dropdown menu using vlookup to find data . If i use the simple example below, using data from B-D on 1 worksheet, where i want to find people by county:

A B C D
Search by County Name County Town
John Sussex Brighton
Eric Yorkshire York
Jim Cheshire Manchester
Liz Sussex Hove
Sarah Avon Bristol

I've created a dropdown menu on a second worksheet,A2, by county search, to return a persons name,county and town. The problem is if i select Sussex i will get 2 names who live in different towns within Sussex. I've created a simple vlookup which works fine, but because of Sussex having 2 results, i created a second vlookup for the second result to appear in the cell underneath.

The problem is that for the results that only have 1 result, the second vlookup returns a the same result as the first result, which i dont want.

Is there a way where multiple results will be shown if they exist, but for one result to appear if only one result exists?

## Copy / Paste From Cell In One Sheet To A Cell In Another Dependent On Selection Of Dropdown Menu

May 31, 2012

I have a workbook with two sheets. The idea behind the workbook is an Interview Guide to be used just before an Interview. For now my problem is this.

Sheet 2 "Competencies" is just data. It stores competencies with their associated definitions and questions.

Sheet 1 "Control Page" is the sheet where the questions will eventually go. The user (Interviewer) will input data on the first two pages which will include name of candidate, date of interview etc. but they will also select 5 Competencies from the already existing drop down menus on page two. From there as the selections are made I wish for a code to copy the corresponding definition on sheet 'Competencies" to cells lower down in sheet "Control page".

I don't see a place to upload a file as I have a sample of the sheet ready to go.

## 3 Different Tables - VLookup Depending On Selection From Dropdown

Jun 12, 2013

I have 3 different tables on a sheet which I want to do a vlookup on depending on the selection from a dropdown.

I created the ranges I want to use in 3 cells and tried to reference the cell rather than the range. Excel no likey:

Is there anyway I can do what I am trying to do?

Oct 18, 2008

I have a column with various drop down menu boxes and I need to add another selection to the menu list. My problem is, it's been so long since I did the drop downs, I have forgotten how to do it..

## Displaying Input Box Based On User Selection Of Dropdown Selection?

Jun 3, 2013

If a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.

## Automatically Run Through Dropdown Menu?

Jul 7, 2014

I've got a workbook with multiple worksheets related to several subsidiary companies for each state & territory, resulting in 450+ worksheets in the workbook. I created a summary sheet with a dropdown menu for each state/territory that pulls in the relevant data using "=indirect". For example, selecting CA from the dropdown menu populates the combined revenue, expenses, etc., for all subsidiaries in CA. However, I've got 50 states plus some territories. I'd like the revenue, expenses, etc. for every dropdown option. Ideally, a separate sheet (or whatever) that lists all 50 states and the revenue, expenses, etc., for each one below (or across).

Is there any way to do this automatically so I don't have to select every single option and copy and paste the numbers into a different worksheet?

May 5, 2014

How can I write my code so that the drop down box always is visible ( like a combobox)? This code is correct and makes a drop-down list but I want it visible at all the time.

[Code] ....

## How To Create Dropdown Menu

Feb 12, 2013

i looking for a drop down menu ..! like year , month so that no change that area

Jan 8, 2009

Included is an example of a spreadsheet I am working on. There are multiple choices within several different drop-down menu's. As of right now I have the 1st menu as the stage of completion of a car. Within the next few menu's are options.

If welded chassis is chosen, none of these options are included. However if roller or turn-key are chosen then some of these options are included. But then there are also upgrades to these parts that are included as well. Is there a way to make 1 option included when a roller is chosen, but then if you want the 2nd option in the menu, you click on it and it automatically updates the price next to it, therefore subtracting the cost of option 1 from the cost of option 2?

## Different Output When Choosing From Dropdown Menu?

Dec 23, 2013

I'm looking for a way for excel to output data to a cell dependent on what I choose from a drop down menu.

For example. I have a drop down menu with 3 options. 1,2 and 3. What I want is that if I choose option 2, then in cell A2 (or whatever) would output the value of 2, say "2222". Or if I choose 1, then A2 would output the value of 1, say "12345".

Jul 27, 2014

I have a normal validation dropdown menu/list. (say it is based on the cells B1:B20)

When i use a filter and the results are cell B1,B5 and B8 the dropdown menu still shows cel B1:B20

How can i make it only show cell B1,B5 and B8?

## Dropdown Menu To Get Contacts In Sheet

Dec 20, 2012

i have a excel sheet which i use to estimate of course i have many contractors i use

my question is, is it possible to create a drop down menu with the contractors name and autofill the cells below with the address

Cell_B5 Company (Dropdown)
Cell_B6 111 Street Rd
Cell_B7 TownCity State 11111

or is it without a dropdown possible by just typing the first few letters and then autofill and how to do this

Jan 14, 2013

Need to create a drop down menu for a cell that allows selection of 1 of the 5 to 10 alternatives by clicking on an item in the drop down. Have seen this done by attaching a down arrow button to the cell.

What is this feature called, and how do I go about setting this up?

Jul 5, 2013

In Column A I have product names. Each product name in column A is followed by several rows of data related to that product directly below it. The number of rows following any given product varies and is also dynamic as rows of data are added to other products above it.

I want a simple downdown menu in A1 that is populated with every product listed in Column A. When a product is selected, that area of the worksheet showing that product is shown.

## Dropdown Menu With Hidden Values?

Aug 2, 2013

I am building a workbook which will be used to quote cleaning jobs and i want to add a drop down selection menu with hidden values which will calculate timings for jobs - for example

if you select DOOR WITH VISION PANEL i want that to have a hidden value that is the time it takes to clean e.g. 1 minute the auditor then enters the number of doors lets say 3 and the spreadsheet can then calcutale that 3 doors with vision panels will take 3 minutes to clean

## Dynamic Dropdown Menu / List

Aug 22, 2013

I have a successful dropdown menu that removes items that have already been selected through the dropdown list, however, I need it to be able to handle IDENTICAL items. At the moment, it can only handle unique items.

I'm trying to create a Rota Planner. I have a selection of shifts that need to be selected for each day. Some shifts are repeated (meaning that there may be 4 members of staff on the same shift). As ONE of each of the 4 shifts are selected, I then want only 3 to be displayed in the dropdown menu to be selected, until all of them have been selected.

I've tried to break apart the code that provides dynamic dropdown list for UNIQUE values but I'm tearing my hair out and getting nowhere.

Aug 14, 2007

I have a worksheet that have a dropdown menu with more than 60 names / project when I select a name / project all my sheet update per the project. My question is how to run a macro to print all records in the drop menu one time instead of doing it sheet by sheet!!!! and I want to print them pdf.

Nov 28, 2011

I created a Validation list from 2 to 20. I want to have it (the list) add a row every time you select the proper data.

Example: If I want to add 2 row I would select the 2 in the drop down menu. If I need 5 rows I need to select 5 from the drop down menu.

Is this a VBA code? Or can I use a formula?

Sep 12, 2012

I am trying to create a drop down menu in Excel to display certain values but it's not working. I want to input certain data in the cells. eg, 019, Quebec, Agent, Direct etc. I want to create a drop down list where if 019 is selected, all 019 entries would show up hiding all others. When nothing is selected all values would show up. I created a list but if I have 10 "Agent" entries in the cells, the drop down list also shows 10 "Agent entries rather than letting me select "Agent" and then displaying all agent entries below. I don't know if it makes sense but I basically want to make it easier for people to look for certain entries that they need rather than going through the entire spreadsheet to find all 019's.

## Dropdown Menu To Choose Dates

Jan 5, 2013

I want to create a drop-down menu to choose dates and if I choose certain date the data of numbers (23 sets of number (4 digits)) will comes out in the next column beside the drop down menu of dates, then if the 23 numbers already comes out it will highlight how many numbers are the same in the previous date to the current date. So, each time I choose different date the data for that specific date (23 numbers) will comes out.. I try to do it but I get error when I change to different date the data for that specific date doesn't comes out.

## Retrieve Dropdown Menu Data Using VBA

Jun 21, 2014

Most of the information I need I am getting using standard web queries. But pulling data directly from drop down menus seems beyond the capabilities of a regular web query.

I only need the information that shows as the menu options. I don't need any information from the pages at those links. Nor do I need the links.

Actually all I really need is the option value information, and the date. So for the first item, I would be looking for, 7|2014|u 06/18/2014

## Show Current Selection In Drop Down Menu

May 4, 2009

Hi guys i am in assistance of your brilliant brains, i have a working drop down menu which when selected i can select my data range such as below: ...

## Making Dropdown Menu That Will Change Formula?

Dec 10, 2013

At the moment if a pupil has done foundation listening then I write their numerical result in, for example C3 or if they have done higher listening I write it in F3 (and it works out the UMS and then the grade), but I wondered if there would be any way to just put a dropdown menu in a column for each name, or change it so that I can type in H or F that will change which data is used? Because the UMS and grades are different depending on whether the pupil has done higher or foundation I am unsure how to format it

## Formulas Based On Results From Dropdown Menu?

Dec 23, 2013

I am building a sheet that facilitates managers at our company decipher information that is given to them on a daily workbook I created.

I want to have a drop down menu in Col J, that refers to the major questions they will ask.

Time started (Before)
Time Finished (After)
Number of Cards (More than)
Stops Per hour (more than)
Amount of Time Taken (More Than)

I have set up in Col (K) a secondary drop-down list which based on the question selected in (J) will offer options for the answer E.G Time questions will make (K) refer to options based on time and selections based on amounts will offer numbers as an answer.

The elements in brackets are the parts of the formula that create the search option. E.G If select 'Time Started' it will search for all records that started before the time selected in the next col (K)

Right if that makes sense.. I have completed this. so I have the following: A question drop down list in (J), and an answer drop down in (K) which is dependant on the type of question asked. (I have attached an example)

I want to now have a totals box after the question where it displays a total amount of cols that are true to the details in the question.

After that (if possible) I will want to use conditional formatting to highlight the ones that reflect to the question.

Realistically if possible i wouldnt mind creating a question box, a box that allows them to select 'more than', 'exact' or 'less than' and then the specific value. Basically a conditional formatting box for dummies within the worksheet. Attached is a demonstration.