If I have followed this one correctly: http://www.excelforum.com/showthread...=1#post4559541 the OP has 1E11 records he would like to perform lookups on. My advice at this point is to use database tools to query the database (databases?), but I do not know databases and Excel. If anyone would care to jump in....