Hello,
I am trying to use the INDEX MATCH MATCH function to return values from a table for different combinations of inputs. I am also having to use MROUND to get the input values to match the table, and this seems to be causing a #N/A error.
The formula I had was as follows: =INDEX( [tablearray] , MATCH( MROUND( [input1] , 0.05), [lefthandcolumnoftable]) , MATCH( MROUND( [input2] , 0.05), [toprowoftable] ) )
I have also broken out each step to simplify the issue and it definitely looks like MROUND is throwing it off - the formula works fine when the input values already match the table values exactly.
Can anyone give me a way round this problem?
I am trying to use the INDEX MATCH MATCH function to return values from a table for different combinations of inputs. I am also having to use MROUND to get the input values to match the table, and this seems to be causing a #N/A error.
The formula I had was as follows: =INDEX( [tablearray] , MATCH( MROUND( [input1] , 0.05), [lefthandcolumnoftable]) , MATCH( MROUND( [input2] , 0.05), [toprowoftable] ) )
I have also broken out each step to simplify the issue and it definitely looks like MROUND is throwing it off - the formula works fine when the input values already match the table values exactly.
Can anyone give me a way round this problem?