A formula in Excel that will input a value from another sheet if a certain criteria is met

Excel Help for A Formula In Excel That Will Input A Value From Another Sheet If A Certain Criteria Is Met in Analyzing Corporate Financial Data

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?? Cheers
	Dave
	Posted by daveA on 17 Jun 2010

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	The INDEX function Rate this: (3/5 from 1 vote) 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. 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 17 Jun 2010

Displaying page 1 of 1