Function Help
That worked, that work perfectly. I hate to be a pain but what is the
difference between enter and ctrl + shift enter
Thank you so much for your help!
"Peo Sjoblom" wrote:
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?
|