Forum Discussion

Tom Sargeantson's avatar
Tom Sargeantson
Copper Contributor
Nov 22, 2017

Pass an array as an argument to lookup formula?

Hello,   I have a formula that returns an array of values, and what I'd like to do is expand the formula to take that array, perform a vlookup or index/match on each value in the array to return ...
Formulas & Functions
Need Help
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Nov 24, 2017

Tom,

 

yes, this should be possible.

 

  • Tom Sargeantson's avatar
    Tom Sargeantson
    Copper Contributor
    Nov 24, 2017

    Thanks Detlef. Any suggestions as to how?

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Nov 24, 2017

       

      A few.

       

      {=SUM(VLOOKUP(T(IF({1},criteria_array)),lookup_range,column_number,FALSE))}
{=SUM(INDEX(output_column,N(IF(1,MATCH(criteria_array,lookup_column,0)))))}
=SUMPRODUCT(SUMIFS(output_column,lookup_column,criteria_array))
      • Tom Sargeantson's avatar
        Tom Sargeantson
        Copper Contributor
        Nov 24, 2017

        Thank you for the help. Will try it out.

Resources