Examples of question formulas that use lookup questions
The following question formulas extract information from an Excel spreadsheet determined in lookup question Q11, "What is the file name and path of the components spreadsheet?"
= GetCellNumber (Q11, "A3")
Retrieves the numeric value of cell A3 in the Excel spreadsheet defined in Q11.
= GetCellText (Q11, "A3")
Retrieves the text value of cell A3 in the Excel spreadsheet defined in Q11.
= GetCellText (Q11, "Sheet1!D4")
Retrieves the text value of cell D4, in worksheet 1, in the Excel spreadsheet defined in Q11.
= 250 + GetCellNumber (Q11, "C5")
Adds 250 to the numeric value of cell C5 in the Excel spreadsheet defined in Q11.
= GetCellNumber (Q11, "Area")
Retrieves the numeric value of cell named 'Area' in the Excel spreadsheet defined in Q11.
Tip: Estimating
names each question in the model Q#, where # is the number of the line
that contains the question. Select a line and click 
to
open the Properties window, where you can change the name of a question.