I’m using MATCH within the INDEX fn to come up the column number…within MATCH I’m using a modulo calculation.
I have a two dimensional table with a decade of factors so that once they hit the 11th duration it goes to the next line to pick up the next decade.
I can figure out the “row” part of it easy enough. For the column part I’m using this…
IF(MOD($G3,10)=0,10,MOD($G3,10))
…where G3 is the duration.
Assume the table is what it is and there’s no changing it now.
I’m just wondering if there is a more elegant/clever way to find that column number?
This method works & it’s not a production-level work product…more scratch paper than anything…I’m just curious if there’s a better mouse trap out there.