I can get the match function to tell me that something is in column 3
I can get the address function to return the reference of a column and a row: ie: $C$3
But I can't get a function that just says "hey it's in column $C:$C,
the goal is to have the sum range in my sum if/sumifs formulas not be static but instead be able to change based on whatever my lookup value is. So that way I can have a more dynamic formula and not worry about always making sure everything is in the same column or maintains the same column format
So match formula tells me the column a lookup is in, then i want the sumif formula to sum the range of that column. This would have many other applications though
See the attached excel file for a more detailed example of what i'm trying to do.
I would prefer a non array formula solution as i suck at array formulas at the moment
Thanks for any help
Bookmarks