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:

Cells(7, 3).Value = Application.If(cboPart.Value = "Other Customer", Cells(6, 3).Value, (VLookup(Cells(3, 3).Value, Sheets("FS").Range("A1:AE100"), 2, 0)))

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.

    If cboPart.Value = "Other Customer" Then
        Cells(7, 3).Value = Cells(6, 3).Value
    Else
        Cells(7, 3).Value = Application.VLookup(Cells(3, 3).Value, Sheets("FS").Range("A1:AE100"), 2, 0)
    End If