My formula to return the value of "Total Income" for each company is:
Works beautifully. No problems at all. LOVE the Index/Match.
The problem is the Index range reference
$H$19:$ZZ$19 might change to Row 20 the next month if new lines are added (each month new report pasted in, so it doesn't know cells have moved). If I were doing this every month, it's easy enough to find and replace all and done, but I'm not and the other users can't.
So, I am trying to make sure it works each month, no matter what. I did find the way to return a row number by using the
Match("Total Income"...), but is there a way to be able to look up the text string, "Total Income", to get the row number to go in my Index formula?
Since the match string worked bringing back the row number,I even tried putting that equation in the index range (...$H$MATCH("Total Income",'Monthly by Class'!D:D,0). That didn't work as expected, but I was just wanting it to put row 19 there. There must be a way.