You need to enter the formula with

ctrl + shift enter

as opposed to enter only

--


Regards,


Peo Sjoblom




"Erika" wrote in message
...
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?