Home > Forum Home > Analyzing Corporate Financial Data > Questionnaire on Excel help? ASAP! > Lookup from source values Share

Lookup from source values

Excel Help for Lookup From Source Values in Analyzing Corporate Financial Data


Forum TopicLogin

Lookup From Source Values

Rate this:
(3/5 from 1 vote)
GratefulIf you are using form objects for the questionnaire, then the options will be coming from some source ranges.  If you attach a cell link to the form object, then it will return the index number of the option chosen. The destination sheet then needs to take in INDEX function with the index number of the option chosen against the source list range to return the text of that option. For example, index 1 would return "male" and 2 would return "female".
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Lookup from source values in the