First, your ranges all need to be the same size.

Second, you don't need the INDEX() function within the ISNA() function.

Third, your need to array-enter the function, with CTRL-SHIFT-ENTER or
CMD-RETURN. Try:

=IF(ISNA(MATCH($A9 & C$7, $A$37:$A$118 & $B$37:$B$118, 0)), 0,
INDEX($C$37:$C$118, MATCH($A9 & C$7,$A$37:$A$118 & $B$37:$B$118, 0)))


In article ,
Erika wrote:

I keep getting an error with a formula that I am working with. When I build
the formula through the Function Wizard I can see the result but when I click
on OK I get a Value Error.

Here is the formula

=IF(ISNA(INDEX($C$37:$C$118,MATCH($A9&C$7,$A$37:$A $98&$B$37:$B$118,0))),0,INDE
X($C$37:$C$118,MATCH($A9&C$7,$A$37:$A$118&$B$37:$B $118,0)))

What am I missing?