Five minutes is too slow. Can you let me know the number of records/rows second workbook has?
Also, can you link the second workbook with the book on which you have dropdowm using reference. This will avoid Vlookup searching values from different workbook
<a href=”http://findsarfaraz.blogspot.com”>MS Excel help</a>