How do you use a string in arg1 of vlookup?

I'm getting "Unable to get the VLookup property of the WorksheetFunction class" when using a string search.

    Dim HRCList As Range
        Set HRCList = Worksheets("New HRC List").Range("B9:L98")
Dim PortsList As Range
[ t]Set PortsList = Worksheets("Remote Apps").Range("B9:I98")
    Dim GetApp As String
    Dim GetPort As String
    Dim TotalApps As Integer
    Dim TotalPorts As Integer

This one works because I didn't define a string search. Before I got this to work, I was using a string in arg1. This string was equal to the argument in the formulat now and it didn't work. Obviously there is a catch I'm not getting.

    TotalApps = Application.WorksheetFunction.VLookup(Worksheets(" Customer Data").Cells(Counter + 2, 18), HRCList, 3, False)

This one does not, because of the string.
    GetPort = Application.WorksheetFunction.VLookup(GetApp, PortsList, TotalPorts + 2, False)


Thanks for any help you can provide.

dem

I hope someone can help me. I'm having trouble with my VB Vlookups with a string as the search arg1.

The following doesn't work because SystemCode is a String:

   ProductName = Application.WorksheetFunction.VLookup(SystemCode, Worksheets("New HRC List").Range("B9:C98"), 2, False)

This works because the SystemCode is defined:

   ProductName = Application.WorksheetFunction.VLookup(Worksheets(" Customer Data").Cells(Counter + 2, 18), Worksheets("New HRC List").Range("B9:C98"), 2, False)

What syntax will work with a string?