I am using vlookup and I want to obtain the value in column B for the second occurance of the lookup value This code comes up with error

DestCity = WorksheetFunction.VLookup("**Line#1 CITY**", Range("CPARSdata"), 2, 0) _

And WorksheetFunction.VLookup("**Line#1 CITY**", Range("CPARSdata"), 2, 0)

If I use the first part before the "And" it will find the results to the first occurance.

Please help!