Autofilter Without Exact Values?

I am writing a macro that will take data from a series of objects and then filter 3 columns according to their attributes.

EX.

Object 1 Example1 20140306 10

This combination of values is unique so is used to grab the value in the third column after the filter has ran.

My issue is that in the second column the actual values are 50201403069999 and they change per value although they represent the same date "20140306" so manually I can type in "20140306" and the filter will show the results however it seems the macro requests the exact which I can't provide as this the superfluous numbers change.

Is there a way to make it the auto filter search the value??

My second issue is how to extract the value sought once found. Since this cell will be different each time, what is the best way of selecting would it be C3 select then down?

Here is my current code:

Code:
Sub IMPORTPRICES()
Dim i As Integer
For Each Ativo In Sheet4.Range("A2:A6")

[Code].....