Function Help
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,INDEX($C$37:$C$118,MATCH($ A9&C$7,$A$37:$A$118&$B$37:$B$118,0)))
What am I missing?
|