| Home > Forum Home > Analyzing Corporate Financial Data > array of values in the dropdown > Cell Link and INDEX function | Share |
Cell Link and INDEX function
Excel Help for Cell Link And Index Function in Analyzing Corporate Financial Data
| Forum Topic | Login |
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 | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Cell Link and INDEX function in the Excel Business Solutions Directory |