title: Return array from INDEX function?
body: <p>I have to do a computed fields in Excel table which summarize values from a table joined with values from a domain table. E.g. have table of goods with name and count and domain table pricelist with goods name and price. The goal is to lookup price for each goods row, multiply it by the price and sum this all together. Some of the goods lines may repeat and some may miss so it is not possible to do the vector product.</p>
  
  <p>In fact the real case is a bit more complicated.</p>
  
  <p>I can do a lot with MATCH and INDEX functions and array formulas. But my showstopper is that INDEX function cannot return array of found values based on array of indices passed in. This formula always ends up with value 1, not an array as I would expect:</p>
  
  <pre><code>{=COUNT(INDEX({1,2,3},{3,2,1}))}
  </code></pre>
  
  <p>Just note that I cannot use LOOKUP functions as they require sorted lists...</p>