looking for correct syntax

trying to write a formula in a VB to some cells:

Please Login or Register  to view this content.

This is what I have and is returning a run-time error. Anyone know how I should be writing this?

Assuming kk is a numerical value my only point would be:

count your parentheses... ;-)

=IF(ISNA(VLOOKUP(...)),..,VLOOKUP(....))

To debug is divine.

Set a string variable equal to the formula, then print it to the Immediate window before it gets stuck in a cell. If you see what's wrong there, you can fix it; if not, paste it into a cell and let Excel tell you what's wrong.