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.