Re: $$Excel-Macros$$ Required fastest vlookup formula

I have previously dealt with similar situations. In one case, I have an application that has over  164,000 rows and 74 columns.Frequently, queries and reports retrieve records based on multiple columns. VLOOKUP became much too time consuming, but due to the volatile nature of the data,

$$Excel-Macros$$ Required fastest vlookup formula

Hi Friends, We have more than 3 lacks data in our excel,so put the vlookup formula it will take huge time. Please help as the fastest vlookup formula or VBA *Regards* Karthik.N Virus-free.