I am filtering a worksheet then using VLOOKUP() to return values. Problem I have is that the VLookup() is ignoring the filter condition. How should this formula be changed to only search visible (filtered) cells?

Set lookupRange = Sheets("LooksIt").Range("$A:$C")
Sheets("LooksIt").Select
Selection.AutoFilter
ActiveSheet.Range("$A:$C").AutoFilter Field:=2, Criteria1:="<>"
showData.Cells(i, "P").Value = Application.VLookup(showData.Cells(i, "A").Value, lookupRange, 3, False