Array of values in the dropdown

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

Forum Topic

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:

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

Find relevant Excel templates and add-ins for array of values in the dropdown in the Excel Business Solutions Directory