Lookup In Table Based On List Choice
Aug 22, 2007
I have a way of getting a cell value from having a data validation linked to a row of cells containing lookup formulas.. which in turn are looing at a table.
I have attached a small example.
The problem is the spreadsheet is a large one and i was hoping I could shrink the size of this by removing the vlookup formulas by having some kind of index/match/lookup formula inserted directly in the data validation.
I got this to work using nested IF formulas but its not very practicable!
The attached example has data validation in column A that selects the task type. Choosing this then changes the values in the vlookup area.. which then becomes the validation list for cell in column B.
View 9 Replies
ADVERTISEMENT
Feb 6, 2008
I currently have a drop down menu in one of my worksheets, in which I have several different text values entered. What I would like to do is link each of those text values to a numerical value, which would be entered in to another cell. So if I select "Option A" from my drop down list, and Option A is equal to 200, I want "200" to show up in another cell. If I select "Option B" from my drop down list, and Option B is equal to 400, I want "400 to show up in that same other cell.
View 4 Replies
View Related
Aug 12, 2007
I'm trying to continue on this post: Populate Cells After Choice From Drop-Down
I'm trying to expand on CNL's idea. What I need to do is create a spreadsheet that autopopulates two blocks based on the dropdown box that preceedes it. I've got it to partially work, but can't figure out the next step. The differnce between my sheet and CNL's sheet is my drop-down is an indirect data validation.
The easiest would be to have my data in one long list, but my goal is to make it easier on the user to find the specific procedure (I'm trying to build a budgeting spreadsheet for a medical office). So in box A15 there is a list of the different service area, which gives a list of choices in C15 based on the choice selected in A15. My goal is to have G15 and G16 list the cost and charge respectively.
M1 - O3 is the data for Radiology
Q1 - S4 is the data for Labs
U1 - W4 is the data for Office
View 9 Replies
View Related
Jun 22, 2008
1. I am starting with two independent tables, one with ‘ItemA’ and the other with ‘ItemB’
2. The user must be able to select an itemA which will point to itemB list, showing only a specific pre-defined group or combination of the itemBs.
3. This pre-defining of the itemB combination will be done uniquely for each itemA selection
Example: Selection of an itemA, row 2 will show, say, an itemB rows 2, 4, & 7 only. Selection of itemA, row 3 will show an itemB rows 4, 5, & 9 only. Selection of an itemA, row 4will show an itemB rows 2, 7, 11 & 13 only, etc.
4. In reverse, the user also needs to be able to select an itemB and display all itemA’s common to that itemB. Using the example above, the entry or selection of an itemB, row 2 will show rows 2 & 4, itemA.
This is represented visually in the attached GIF.
View 5 Replies
View Related
Dec 7, 2013
I want to make a lesson table which distribute the names to lesson choice priority.
You can see detail and explanation at attached file. LessonChoice.xlsx‎
View 3 Replies
View Related
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]
View 9 Replies
View Related
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.
View 3 Replies
View Related
May 9, 2009
I'm working on making a spreadsheet that allows me to select an item type from a dropdown list (through validation) and then would copy in a range of values from another worksheet based on my dropdown selection.
The set-up: I am primarily concerned with two sheets in my workbook, BiS and Weights. I have a database of items and their associated values listed in Weights. I have already managed to get dropdown lists of my specific item types using named lists and have put that in the BiS worksheet.
What I would like to do is have the values in the Weights worksheet copied over in the same order and number of cells based on what item I select from the dropdown list.
View 6 Replies
View Related
Nov 14, 2006
I have created a cascading data validation list, and I would like to have an adjacent cell auto populate according to the dropdown selection.
Data Eg:
Oranges 1100
Apples 1101
Pears 1102
Grapes 1103
If the user selects "Pears" from the dropdown list, I would like the adjacent cell to populate with the numerical code for "pears", in this case 1102. I am designing a new expense report form at the office, and I am at a standstill with this problem.
View 2 Replies
View Related
Sep 3, 2007
I'm looking for a method, vba macro or Excel code, to preform the following task:
In the C column the user chooses one of several options from a menu, let's call these options 1 - 10 (this part is already done). Depending on the choise, different things are supposed to happen:
For 1-9, the formulas for cell A - Q on the current row should be copied to the next row (but with +1 in row number in formulas of course).
For 10, 3 blank rows should be created (well they already are blank..), on the forth row down, A3 - Q3 should be copied exactly. On the fifth row, the same formulas thing that was created for choise 1-9 should be created.
Since the real xls-file is too big already and it contains some sensitive information, I can't attach it here, but I made a small and similar xls-file, that better explain what I want to do.
View 8 Replies
View Related
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.
View 6 Replies
View Related
Sep 22, 2009
In all the cells in column F I have a validation list with several predefined choices, but at the bottom of this list I want an "Other..." option, which when chosen, enables the user to enter a new string in that cell if none of the predefined did not match.
View 7 Replies
View Related
Oct 4, 2006
I'm trying to do is build a form that will allow me to select from a list of options, that links back to a catologue of data so that when i click on the generate button it will pull the data associated to the item selected from the list into a text box in excel. I have attached the form that I have created.
View 4 Replies
View Related
Aug 10, 2008
I'm working on a simple worksheet, it is a tracking sheet for programs taught. What I'm trying to find is a code to insert a row based on a Data Validation List.
Exampl of data:
Column A is for " Name" then futher down Column K is "Program Taught" and Column L is " Date Taught".
Column K is where the Data Validation List is located with a in cell drop down.
What I would like to do is when a user selects a program from Column K a row is inserted with all of the formulas and formats from the previous row, and upon insert would like it to copy Column A into the new row.
This would be so I can keep a historical of programs and dates taught.
And to really spice things up I want to lock Columns K & L of the previous row after the new row is inserted.
View 4 Replies
View Related
Jul 9, 2007
If there is away, to restrict the Time Out ( Cell B2), according to Time In (Cell A2), I mean if Time In is empty, then there should be no Data in list of Time Out, and if the Time In is 8:30, then the Time Out should have greater than or equal data in its list...
See the attachment
View 9 Replies
View Related
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?
View 13 Replies
View Related
Aug 9, 2007
getting a macro to dynamically assign a drop down box to a list of numbers?
Specifically, I have a list of numbers in column A, and I would like to dynamically (because the size of the column differs every time) add drop down boxes in column B so that a user may select different values in column A, simply by changing the drop down box value to "Selected"
This would this make it easier for collect all the "Selected" values and perform further analyses upon them.
View 5 Replies
View Related
May 15, 2009
I want to compare a hand entered data sheet to my system data. System data is exported in. Then that data is used to populate a pivot table. I use a lookup list that fills in matching data from my hand typed sheet. From there I want to use true/false to see if the data matches. However, the formula will not copy down. I am sure it has to do with the formula holding a value, but I can’t seem to correct it.
Recap
1.System data populates sheet
2.Pivot table pulls info I need.
3.Lookup list cross references hand entered data sheet and puts value next to pivot table.
4.I need to do a true false to see if data matches but can’t get it to work
Example worksheet: On the worksheet you can see that the true false statements are incorrect. The system data and the hand entered data match two times not once.
View 3 Replies
View Related
Oct 18, 2006
is there a way to force so that a cell value can be only of what a validation droplist offers, hence users can not enter their own values and have to use the droplist for cell content selection.
View 2 Replies
View Related
Dec 1, 2007
I created a Vlookup table so that when you type a ticker into Cell B3, it tells the user how many points and what percentage of the criteria the stock passes. I would like to create a macro (or something) that takes each ticker in the Ticker sheet, enters it in the Cell B3, and then transfers the data that the vlookup table produces to the output sheet. My attachment is a simplified version of the real spreadsheet.
I hope this isn't a duplicate question. I did look, but maybe I'm not phrasing it correctly. A reference to a similar problem works too.
View 3 Replies
View Related
May 16, 2013
I'd like a formula that'll return the column header by matching a lookup value with a table in the second sheet.
eg: sheet 1
Name
Cell
Region
John
111-2222
[Code] .......
The formula should match the name in A2, John, with value from the table in sheet 2 and return the correct region, this case North.
View 1 Replies
View Related
Dec 21, 2007
I have a list of holiday data which has the following info. Name, Date from, date to, hours off per day. I need to look up this information and place the number of hours against each day for each person. The problem I am having is that I can't get the hours into the cells for which the date is between the date from and date to. I have attached spreadsheet and how I want the summary page to look. I just need the correct formula inserting.
View 6 Replies
View Related
Apr 23, 2013
i am attaching a sheet here.
i have put data validation list in three columns
from data lsts i select unit type , then hinge type then code.... the problem is that as soon as i select code all the values (H W D ) in the next three cells should automatically change.
the values against each cabinet code are also provided in the same sheet.
Sr No.
Unit Type
Unit Type
Code
H
W
D
Qty
1
Base Unit
Double Hinged Door
B60
720
600
580
2
2
Base Unit
Single Hinged Door
B30R
720
300
580
4
View 2 Replies
View Related
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.
View 3 Replies
View Related
Nov 20, 2006
I'm trying to set up an Input Box that allows the user to have a set of options to select from. The only things I have found deal with a MsgBox with set options of Yes, No, or Cancel. I would like to allow the user to have multiple buttons, check boxes, or radio buttons to select from. (any of those will work). For example: "Select the Customer Service Representative you worked with: "
-Amy -Jill -Joseph -Christopher
View 5 Replies
View Related
Jan 8, 2008
I check the FAQ and couldn't understand the advice. How do you create a list to select a number of items to use in a spreadsheet. I wnat to us this list mutiple times in the same spreadsheet.
View 5 Replies
View Related
Mar 14, 2008
I have a pivot table that I need to copy only certain regions from the Report Filter on a frequent basis. For example, in the Report Filter, I have 18 total regions, but I only need to submit a pivot table for only 6 regions on a weekly basis. Currently, I'm filtering the 6 regions individually from the "data dump" and making 6 pivot tables as separate workbooks...and then emailing them out. I need to make the underlying detail available for each location that is getting their "report". I have the code for emailing a single worksheet from a workbook so, at least, I have that little tidbit taken care of.
View 2 Replies
View Related
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.
View 1 Replies
View Related
Jan 13, 2007
I have to introduce often the same entry (i.e. a firm or commerce name).
To avoid having to make all te time the same entries and to avoid entring the same firm with different spellings I imagine making a choice from a list, list that would be able to "learn" new entries.
Example: When I type the "D" of "Dupont de Nemours", Excel would propose all entries beginning with a "D", and if I introduce a name that doesn't still exist in the list, I should be made attentive to that fact and proposed to add that name to the list.
View 14 Replies
View Related
Mar 12, 2009
I have a Range on one sheet formatted like this and sorted by Sup then Rep:
Rep Sup
John Sally
Mark Sally
Joseph Sally
George Betty
James Betty
etc..
I have a Validation Drop Down list where a Supervisor is chosen. There's a specific range that I would like to automatically fill in with the reps assigned to the Sup. This is driving me crazy! I already know how to obtain that list as another Validation Drop Down, but not quite sure how to make those values appear in a range instead of a Validation List.
View 2 Replies
View Related
