One general thing I see -- lookups (especially the linear "exact match" lookups that everyone seems to prefer) are very slow and are a common bottleneck. They are even slower when they are performed on a closed workbook. As a general rule (and every general rule of thumb will have its exceptions), whichever strategy will reduce/minimize the number of lookups (especially on closed workbooks) will likely be faster.