Use VLOOKUP to Find the Last Match in a List

VLOOKUP is an awesome Excel function. We all know this. But it certainly has its limitations. One of these is that it can only return the first match from a list.

This is great when looking for a unique value. But what about when the value you are looking for appears multiple times in the list, and you want to return the last match.

Sure we could sort the list so that the last match would become the first, but this is not always an option.

This blog post looks at using the VLOOKUP function to return the last match in a list. The technique and formulas used can be adapted to find the 2nd or 3rd match if required.

VLOOKUP to find last match

Continue reading

Formatting Mail Merge Fields from Excel

When performing a mail merge from Excel to Word, your mail merge fields tend to lose their Excel formatting. This is especially common with date, time and currency fields.

This tutorial will look at how you can correctly format date, time and currency mail merge fields from Excel. Once the formatting is applied to the mail merge document it will be remembered for future use.

Continue reading

Top 5 Essential Microsoft Powerpoint Tips and Tricks

Microsoft PowerPoint has revolutionized the delivery of presentations so much so, that it even has its own epidemic – ‘death by PowerPoint’.  This is not so much a result of using it to support presentation but relates to how people use it.  There can be no argument that if used correctly, PowerPoint can turn the most amateur of presentations into ones that are sleek, modern, and digitally useful.

Although PowerPoint training is recommended, here are some essential tips and tricks for anyone using PowerPoint 2010.

Continue reading