View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rock_crushing_design_engineer
 
Posts: n/a
Default 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.