Array of values in the dropdown

Excel Help for Array Of Values In The Dropdown in Analyzing Corporate Financial Data

Array Of Values In The Dropdown

Rate this: (3/5 from 1 vote)

	Helo Experts I am working in BPC for Excel I need to define a col key range from the dropdown list for exampleExcel Spreadsheet:   A B C D 1    cOUNTRY  CITY STREET 2 DAVID  MUNICH  ITALY  NETHERLANDS 3  ROSE  GERMANY  ROTTERDAM  BACON 4  LINDA  BRITAIN  STOLKWEG  BACON ST IF DAVID IS SELECTED  SELECT NAME: David NetherlandsRotterdamStolkweg               colkeyrangeB2:D2 THIS MUST BE THE VALUE THAT NEEDS TO BE SELECTED        SO IF I CHOOSE THIS COL KEY RANGE THE vALUES INTHOSE COLUMN MUST BE ACCESSED
	mvl
	Posted by applebee on 04 May 2011

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Cell Link and INDEX function Rate this: (3/5 from 1 vote) For this issue, create a ComboBox form object and use the list of names as the Input Range. Create a Cell Link to a cell somewhere in the spreadsheet.  The Cell Link will return the index number of the name selected.  This can then be used in an INDEX function to return data relating to that name on the same row such as Country, City, Street etc.
	Excel Business Forums Administrator
	Posted by Excel Helper on 05 May 2011

Displaying page 1 of 1