VBA compilation error : expected expression error

Hi All,

I have been working on VB and I am getting a compilation error in a particular code.

I am trying to use Vlookup to get the data from an array which is in another worksheet, I am able to get the data using the below formula and it is working fine.

Please Login or Register  to view this content.

But, I am getting #N/A error, So I have been trying to use ISNA function in the VB, but it is showing the compilation error - Expected: expression. Please help.

Please Login or Register  to view this content.

And I am getting the error at the IF statement!!!

You have a few choices really... the simplest perhaps being:

Please Login or Register  to view this content.

Simple addition:

Please Login or Register  to view this content.

Apologies - oversight on my part.