I want to get a value from an array, row 1 and column 1 known.
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.
|