title: how to apply vlookup formula on filtered data/visible cells only
body: <p>I have filtered column "A" and i need to apply vlookup formula on the visible cells in column "A". How do i achieve this in vba . number of total rows in the worksheet are 30,000 and the filtered rows are closed to 100.</p>