Len(VLookup()) Error

I know there are instances where the Vlookup() will not find a value. When it does not I want it to pop up secondary list. The problem is the Vlookup() errors out when it can't find a value.

Please Login or Register  to view this content.

Any idea how to get around this?

Please Login or Register  to view this content.

didn't work either. I still get a run-time error: 1004 Unable to get the Vlookup() property of the worksheet function class.

Please Login or Register  to view this content.

Since it's an N/A error the above code should work, but alas it fails...

Please Login or Register  to view this content.

On error goto worked....