Hi

You are missing two closing parenthesis:

=(IF(ISERROR(HLOOKUP($B7,mm!$2:$23,22, 0)),0,HLOOKUP($B7,mm!$2:$23;22, 0)))

but you don't need the outer parenthesis:

=IF(ISERROR(HLOOKUP($B7,mm!$2:$23,22, 0)),0,HLOOKUP($B7,mm!$2:$23;22, 0))

Regards,
Per

"smartgal" skrev i meddelelsen
...
I have the followig formula:

=(if(iserror(HLOOKUP($B7,mm!$2:$23,22, 0),0,HLOOKUP($B7,mm!$2:$23,22, 0))

And I'm getting an error saying too many arguments. Help!

mm