Help! Something wrong with my VlookUp. Excel keep loading

I can't run my macro well. I have been searching for the problem
but it seems that my vlookup has a problem and I cant figure it out .

My Patient Merge have a lot of data . I think thats what my excel run slow but i have use -"With Application" to run.

Using vlookup manually ,
Lookup_value: Column C in Book1 Workbook
Table_Array:Column J in Patient Merge Workbook
Col_Index_Num: 1
Range_lookup:0

Please Login or Register  to view this content.

Kindly help . I really appreciate your help. I tried a few methods of using vlookup but no avail

Originally Posted by Parth007

Could you pleasse attach the sample files on which you are executing this..

I couldn't attached the sample files due to personal data