Make your Vlookup() more flexible with Match()

Ah, the Vlookup() – the staple of data linking since Excel was a child – 40 years ago…I’ve done a tutorial on it here but I want to explore how to make it more flexible . Let’s say you have a scenario where you need to pull in data and...

Excel and Word together for invoicing

Recently I have been working with a group around using Excel for Accounts. Now let me be completely upfront here first. I personally do not use Excel for my accounts. I use QuickBooks and have done so since I set up in business in the mid-nineties. That’s what...

How do I know what formula to use when?

Formulas, formulas, formulas – everyone’s favourite Excel topic. In this table I have identified a number of FAQs and I have put together a table to help you decide what feature to use when… ScenarioFormula/FunctionPull in missing data from somewhere...