Vlookup after filtering

[mmmarks]

Hi folks,

I have been trying to do vlookup by macro but trick is need to apply formula after table got filtered only applies to visible cells.

First part , dooing filter to A column by "X" then B column by "UK" then appling Vlookup in Column F lookup value is Column C (date).
After getting result again I need to filter with another criteria and apply the Vlookup for the same.

I failed to apply Vlookup for Visible cells

can anyone assist me ??

Thanks for all viewers

[Fotis1991]

Take a look to this.

http://www.excelforum.com/excel-gene...d-vlookup.html

[mmmarks]

Thanks for reply..
But I'm looking for a macro because I need to filter multiple time with diff diff Criterias and need to Vlookup..