1 Reply Latest reply on Nov 3, 2013 5:46 AM by kevin.lynch

    Is there a way to use the lookup function to find a particular row and column and not just a row in the same partition? I can easily do this with the offset function Excel where I can go over 1 column and down x rows

    Matt Gurren

      Is there a way to use the lookup function to find a particular row and column and not just a row in the same partition? I can easily do this with the offset function Excel where I can go over x column and down x rows

       

      I want to add the green colors and the blue. So 100+61=161 for green and blue is 100+60+51=211. I want these in different columns as well.

       

      100100100
      6160
      51