Compile Error: Expected: expression

Can anyone help me figure out why I am getting this error? I am trying to manually write an Array Formula.

Please Login or Register  to view this content.

I do not understand why the word IF is highlighted when I Debug. I have many IF formulas and they seem to be ok. This is what is highlighted but it's just the word IF that seems to be an issue.

Please Login or Register  to view this content.

There is an extraneous quote in front of one of the previous "vbNullStrings that is throwing it off.

Try this...

Please Login or Register  to view this content.

-facepalm- a typo! Thanks for pointing that out. I thought it was telling me I spelled IF wrong lol