I use a lot of Vlookups in code and was wondering if there are any tips to speed them up? Examples is it quicker if the Database list is sorted numerically? Is it faster to use True or False for range lookup? any other ways to speed it up? I already have screen updating off.