Need vba code to replace the excel formula

[Rohith1324]

Hi,

I have the below excel formula which is taking so much time when I apply it on large dataset. - So please help me with VBA Code.

=IFERROR(INDEX(DB!AH:AH,MATCH(1,INDEX((DB!Z:Z=SO!N2)*(DB!AH:AH<>""),0),0)),"")

Regards,
Rohith M

 

[James006]

Hi,
The fastest and easiest solution is to use the Evaluate function in VBA.
There are plenty of examples in the Forum ...