Drop Down List And Multiple Information
Aug 5, 2008
I created a drop down list of contacts for specific accounts:
Primary
Second
Third
Fourth
When I click on each one, I want in adjacent individual cells their name, address, phone, and email. The results should only show up in the same row as per list choice.
This drop down list applies to 20+ accounts so each contact info corresponds to the accounts.
A E F G H I
So: Account... Contact Name Address Phone Email
(DropList)
And do that for all the accounts.
View 9 Replies
ADVERTISEMENT
Apr 25, 2008
I'm trying to categorise a load of expenses against their appropriate budget and sub-budgets. I've got all the budget subcategories in separate dynamic named lists each headed by the main budget name. I want to be able to select the main budget name e.g. marketing or sales etc and then see, in the next column over, only the appropriate subcategories to select from e.g pick the appropriate dynamic list (I've used dynamic lists so I have some flexibility to add new categories at a leter date).
View 2 Replies
View Related
Oct 26, 2009
I have a 5 row list in WA2. Each row holds its data across 3 columns i.e A1description, B1 product code, C1 unit cost. In WA1 I want to have a drop down table in cell B3 that looks at this range and then populates this information into B3, C3 and C4. I have tried data validation but it keeps telling me that it can only look at a single row or single column
View 2 Replies
View Related
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.
View 2 Replies
View Related
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 .
View 4 Replies
View Related
Jan 5, 2008
I have the following in a Validation/Data the following tries to reference and array f2:j11
=if(d5="",teammember,index(teammember,match(f2,teammember,0)))
The array 'teammember' refers to cells f2:j11. Formula returns an error message that it can only refer to a single row or column. Is there a formula
View 9 Replies
View Related
Sep 7, 2009
I have a rather simple problem (tough for me!). I am setting up a food log. I would like to have one column with common food items that I have in a drop down list. The list would be about 20+ things. The other columns would have relevant nutritional info such as calories, fat, carbs, etc.
The problem is how do I make the values in the other columns change depending on which food item I pick from the drop down list?
For example, if I choose bread from the list, how would I get the columns for carbs and calories to change accordingly.
The IF function would be too hard because I couldn't nest 20+ IF functions in the formula for each cell. Also, the drop down list would change as my diet changes, possibly reaching 50+ things.
Also, I would like to manually enter a serving size that would alter the nutritional values in each column (for example 0.5*Calories or Carbs).
It seems so simple in my head, but I can't figure out how to get it to work.
View 6 Replies
View Related
Feb 12, 2009
I am using the VLOOKUP function to pull multiple columns of information from another sheet in the same workbook based on a name. The sheet it is pulling from is a query. I am looking up product names, and in the query there may be multiple results that the function can find.
VLOOKUP only returns the first result that is found. What I am trying to do is get it to dump all the results into a drop down list in one cell. If I attach a drop down to one of the columns of information I am retrieving, then I can select which of the entrys to display, right? I think this should work I just don't know how to go about setting it up to do it.
How would I set up a VLOOKUP formula that attaches a drop down list containing all the results that the function finds?
View 7 Replies
View Related
Jul 5, 2014
The list is a crew list and I'd like to be able to select the foreman, but I'd like the crew cells to be populated with the information corresponding to that specific foreman. I've named the data range and created the drop down list but i cant figure out why the crew column wont populate with the crew. I am using a different sheet for my data.
I tried VBA but I am hoping I can use Index and Match.
=INDEX(crew, MATCH(C10, Personel!D2:F4, 0), COLUMN())
View 2 Replies
View Related
Feb 17, 2009
If I choose 1 thing from a list I want it to then fill in many cells with info.
For example: I have a color list to choose from, once I make my choice cells near it fill in with 1.5lbs yellow, 2lbs blue, 4lbs red,.....or what ever I have established as the "recipe" for my color choice. When I choose a different color from my list these cells each fill in with different values.
View 9 Replies
View Related
Aug 22, 2007
I am trying to create a simple user interface type thing so that someone is able to select from drop down lists someones information, such as whether they are male or female, aged between 19-35 or 35-67, whether they are studying in a business area, legal or construction etc (there are 6 variables in total), This will then give the probability of success of the person passing this course based on probabilities which I have already worked out. I have worked out how to do the first stage of creating a drop down list showing alternative choices with Sex, Age etc in the data validation options, however:
There are 517 possible combinations, as in Male aged 19 to 35 studying Business (with other variables) or Male aged 19 to 35 studying Law (+ other variables) etc etc etc each with their own probability of success. Due to the long nature of writing out Male1935BusinessNorthWestWhiteBritishCollegeBrown I have rewritten it so it appears in the excel file as M1935BNWWBCB, which obviously wouldn't make any sense to someone if they had to select M 1935 B NW WB CB from drop down lists.
Along side the M1935BNWWBCB there is the probability of success specific to that type of person. So for example I could would have:
M 60%
M1935 64%
M1935B 35%....
View 8 Replies
View Related
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.
View 12 Replies
View Related
Mar 27, 2007
I want to use a drop down box to pick a name and then when that name is entered to automatically fill information such as email address, phone number, address into a spreadsheet similar to auto complete that are on many web sites when you purchase from them often.
View 2 Replies
View Related
Oct 23, 2008
I have inserted the sheet. As you can see in Sheet 1 I have the Store, Address, Town etc, I would like a drop down box in D13 ( Store Name ) so when I select a store it will automatically fill all the info into D15:D19 Address, Town etc. The info will be pulled from Sheet 2.
View 3 Replies
View Related
Jan 13, 2009
I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.
For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange
etc.
Is this possible within Excel 2003?
View 9 Replies
View Related
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.
View 3 Replies
View Related
Sep 3, 2009
why my drop down list defaults to the middle of the list when first clicking on the arrow that opens the list? I created an alphabetical list of all US airports but when I open the list, it starts at "D" instead of "A" which is the top of the list.
View 5 Replies
View Related
Jan 26, 2009
I need to create a 'sub' list from a drop down list.
I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.
And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.
View 9 Replies
View Related
May 22, 2008
i have a spreadsheet with several fields. i want to derive information from this data. i want to be able to control the output through the use of list/drop down boxes.
so the user will choose several criteria AND based on this criteria, the ouutput will reflect user requirements.
View 12 Replies
View Related
Dec 1, 2007
I have a workbook with around 35+ sheets on it and I was wondering if its possible if I could put these sheets in a drop down list in say cell A1 so it would be easier to navigate the sheets. Is this possible with out using VBA code if so how would I go about doing it?
View 9 Replies
View Related
Jan 13, 2010
I have a drop down list of shipping Companies. If the name of the company is not in the drop down list how do I allow the user to type in the name then have it save in the drop down list source?
View 9 Replies
View Related
Dec 28, 2012
I am trying to create a drop down list that shows the description of different codes. i.e.
1000 - Straight time
1010 - Vacation Time
1020 - Sick Time; etc.
In the spreadsheet, I only want the number to show (1000, 1010, or 1020).
View 2 Replies
View Related
Feb 19, 2007
I have a wb containing several sheets that the field supervisors use to fill out for ordering material. Each sheet contains different types of material. The problem is that, if they only need one particular item from each type (sheet), they have to print 7 or 8 sheets just for those 7 or 8 items. I want to create a sheet that will list everything they are ordering in one compact, neat area, so they only have to print one sheet.
The set up of the sheets goes like this. There's a column containing the name of all the items. Next to each item is a place they can specify how many of that item they want. They leave it blank if they don't want any. That's it. Really quite simple.
So now, I need this new sheet to find all the cells that a quantity was entered on the other sheets, and list that and the description of the item wanted, along with what type of material it is. I have figured out one way of doing it, but it would take a crap load of hidden IF formulas, and I know there has to be a simpler way. I'm open to all suggestions - whether it's vb codes or formulas, it doesn't matter to me.
View 9 Replies
View Related
Nov 1, 2008
I currently have a drop down list in sheet 1 and the list is being refrenced from sheet 2
Lets say the drop down list is for fruits and my current list in sheet 2 has 4 items Apple, Grape, Mango, Peach.
Now this is what I need :-
1 ) lets say a user wants to enter Orange (which is not in the list ) he can still do so by entering it manually into the cell.
2) Once Orange is entered which is not in the LIST in sheet 2 then that new name gets added to the LIST in sheet 2 so that next time that name appears in the drop down list automatically. eg Apple, Grape, Mango, Peach, Orange [ but Items should not get duplicated eg Apple, Grape, Apple, Mango, Peach, Apple
View 6 Replies
View Related
Nov 3, 2008
I have Excel 2003 installed on the companies computers. Many people use an Excel file and I am trying to make their work easier. There is on command which has a dropdown list made by me. What I would like to find out is that is there any possibility to make Excel help the user to choose from the drop-down list (the list is quite big). Is it possible to select a cell in this column and type in the cell and then Excel help the user. I mean (this list contains country names in abc order) if the user types S and W then Excel auto-corrects it to SWEDEN. Can this be done with Excel 2003?
View 2 Replies
View Related
Dec 11, 2008
I do not know how to create a drop down list to ensure the user inputs only the values from that list. Once I figure this out I would love to add a drop down calender for a cell as well.
View 14 Replies
View Related
Jan 6, 2009
im trying to create a spreadsheet for different makes of cars, here is what i want to do.
in cell one i want a drop down list for various makes of cars, in cell 2 i want another drop down list for the different models from that manufacturer (depending on which on I choose in cell one), in cells 3 and 4 I want different information depending on the make an model of the car. I have got 1 sheel with all this info on it but I dont know how to make it all work nice and neatly with drop down lists.
View 10 Replies
View Related
Jan 23, 2009
i m kinda playing with the drop down list and i decided to make a list about the nba teams.
heres the breakdown:
1st row
conference: east/west
2nd row
east: ATLANTIC/CENTRAL/SOUTHEAST
west: SOUTHWEST/NORTHWEST/PACIFIC
3rd row
the teams list is next.
now ive learned how to do a drop down list but i cant find a way to filter the 2nd row. i hope you can gimme some tips or ways on how to go over this. i tried data>filter but thats not what i need.
here is an attachment and i used sheet 1 for the input and sheet 2 for the list of the selections.
View 7 Replies
View Related
Feb 21, 2009
I have created a drop down list as follows
Whiteboard 16mm
Colourboard 16mm
Colourboard 18mm
Veneer 18mm
Veneer 19mm
Veneer laid up 40mm
Painted 16mm
Painted 18mm.
When I select one of these items I need CELL A1 to return just the thickness. EG: I hit dropdown list and select Whiteboard, CELL A1 then displays 16mm. Or I select Veneer laid up and it displays 40mm. I would imagine this formula would be quite long as I would have these 8 items in it.
View 3 Replies
View Related
Apr 5, 2009
I have a form with 2 columns. in the 1st, we have the product and in the 2nd, we have the price.
I have my drop down list for column1 but I want column 2 to show the correct price when column 1 has a product.
View 4 Replies
View Related
