Can't use If function with Vlookup in userform

Hello,

I'm working with userform and consider using the IF + Vlookup statement. If I only use Vlookup function, it worked. However when I combine with IF function, it got wrong. This is What I'm trying to do:

Please Login or Register  to view this content.

If you know how to fix it, I really appreaciate

The worksheet function If() isn't available to Application.Worksheetfunction; I'm fairly certain that means it isn't available to the application object either. Try this instead.

Please Login or Register  to view this content.