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.