Category Archives: Lookups

VLookup tricks: why 2 VLOOKUPS are better than 1 VLOOKUP

OK, time for a post on VLOOKUP for Bill Jelen’s VLOOKUP week. VLOOKUP Week – Brought to You by Mr. Excel (Click Image for the Official Site of VLOOKUP Week) For all you VLOOKUP junkies who can’t get enough of … Continue reading

Posted in Calculation, Lookups | 44 Comments

Developing Faster Lookups – Part 1 – Using Excel’s functions efficiently – updated

When profiling Excel workbook calculation time I often find that Lookups are one of the main causes of performance problems. So this is the first of 2 posts looking at how to do Lookups faster. This post concentrates on the … Continue reading

Posted in Calculation, Lookups | 10 Comments