If you have to do a lookup on more than one field make a simple combined key by concatenating the "key" fields that you want to lookup on and lookup to. If the key's doesn't change that much (which it shouldn't!) value paste your concatenated key to save calculation time, although I have found that it is very little. The lookup will always sap the most calculation time so depending on how dynamic you lookup should be you can value paste this as well. This WILL save a lot of calculation time.
If you have to delete some records that contain vlookup's or hlookup's, always delete your vlookups before you delete the keys! This is has crashed my Excel a couple of times today.
This concludes my very first entry of What I Learned Today or in short: wil2d.
No comments:
Post a Comment