Highlight your array. Click Insert|Name|Create and check Top row and
Left column.

Then =LAG2 QD will return $88;
or with LAG2 in J1 and QD in J2, =INDIRECT(J1) INDIRECT(J2) will return $88

Alan Beban


rock_crushing_design_engineer wrote:
say I have this ARRAY on a different sheet for reference:

LAG1 LAG2 LAG3
HE $45 $54 $102
QD $65 $88 $205
IO $102 $203 $405

If I input QD in one block and LAG2 in a different block as required inputs
on my input page, what would the equation be to return the value $88 into a
block on my pricing page? All ipages n the same workbook.