VLOOKUP in VBA

[prsnthkrishna]

Hi All,

I have 7lakhs to 8lakhs lines/rows in excel file. I have prepared an excel macro. In Module1, I used LOOKUP formula and it gives incorrect result. So, I changed it to INDEX and MATCH formula. This is consuming time. After writing this INDEX formula, I used text to column formula to get the correct result.
If I do not use Text to column, I'm getting incorrect result.

Is there any other way to get the results with less time. Can anyone help in this. The macro coding file is attached.
Let me know if any corrections to be made in the code.

Regards,
Prasanth Krishna

 

[prsnthkrishna]

Or can anyone give me new macro file for the steps attached??

 

[vletm]

prsnthkrishna
Questions:
Bases Your above written text - what are the steps?
... Please, do not refer to any Word-document
What/where is/are expected results as well as from which file?
How long period is 'less time'?

 

[prsnthkrishna]

prsnthkrishna
Questions:
Bases Your above written text - what are the steps?
... Please, do not refer to any Word-document
What/where is/are expected results as well as from which file?
How long period is 'less time'?

You can find the steps in the word document attached in this request.

 

[vletm]

prsnthkrishna
Yes ...
... three questions
... one reply ( and You missed that my please, sentence )

You could try to modify Yourself Your code
a) the most part of .select - selection - combinations
b) add codes ( if no need formula-calculation while running Your code )

' add in the beginning
With Application
    acm = .Calculation
    .Calculation = xlCalculationManual
End With

' add in the end
Application.Calculation = acm