wil2d: Fridays

On a Friday night the best things happen when you have nothing planned.

wil2d: Personal

After a lot of reflection and recent discussions with someone close to me, it has dawned on me today that I tend to be Patronizing and Judgemental.

On the one hand this is a somewhat disappointing discovery but also exciting because it prompts me to grow.

I will post on my journey to become "not so much of a judge".

wil2d: Vlookup & Hlookup with more than one key or lookup value

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.