|Home > Forum Home > Analyzing Corporate Financial Data > A formula in Excel that will input a value from another sheet if a certain criteria is met||Share|
|Forum Topic||Post Reply Login|
A Formula In Excel That Will Input A Value From Another Sheet If A Certain Criteria Is Met
Rate this:(3/5 from 1 vote)
|A formula in Excel that will input a value from another sheet if a certain criteria is met:|
Can anyone help me with a formula or a way around this: I have an Excel spreadsheet and on sheet number one column A have a list of names with various bits of information on, also in sheet number one but in column C I have a list of percentages (one against every name).
Now what I want to do in the second sheet is create a drop down list of all the names (I can do this bit) and when a persons name is selected in sheet two I want it to drag into sheet two the percentage against that persons name in sheet one.
Can anyone help??
|Posted by daveA on|
|Replies - Displaying 1 to 1 of 1||Order Replies By: Most Recent | Chronological | Highest Rated|
If you have created a Combo Box control on sheet two to select the name from column A in sheet one, then you can specify the cell link in the control properties. The value in the cell specified will return the index number of the name chosen in the drop down box.
Rate this:(3/5 from 1 vote)
To return the corresponding percentage from column C of sheet one for the name chosen, a separate cell can be used with the INDEX function that populates the prcentage. If, for example, the Combo Box cell link is D2 and the range of percentages in C1:C100, the formula would be =INDEX(Sheet1!C1:C100,D2).
Another approach is to use data validation. Here the range of names in column A of sheet one should have a named range applied. A cell in sheet two can have data validation defined from a list using the defined name. The percentage can then be populated by using a VLOOKUP function on sheet one with an offset of 3 (column C).
|Excel Business Forums Administrator|
|Posted by Excel Helper on|
|Displaying page 1 of 1|
Excel templates and solutions matched for A formula in Excel that will input a value from another sheet if a certain criteria is met:Solutions: Technical Analysis Functions Download Market Data Formula Management File Comparison Financial Ratio Calculations Bar Code Generator Employee Timesheet Productivity Add-ins Spreadsheet Auditing Business Planning Templates Marketing Planning Financial Formula Calculations Technical Indicators Spreadsheet Link Checking Input Cell Solver Energy Conversion Useful Add-ins Change Formula References Conditional Rules Formula Analyzer Functions and Formulas Copy Protection Fix Broken Links Formula Cheat Sheet Formula Auditing Data Recovery
Categories: Excel Productivity Market Data Access Sales and Marketing Navigation and Auditing