How to create a Vlookup in Excel

Do you know how to create a Vlookup in Excel? The Vlookup function in Excel is a very popular function but sometimes can be a little tricky to work out. The Excel Vlookup function is a fantastic time-saver as it is a perfect example of how Excel can “do the work for you”. The Vlookup […]

How to use Concatenate in Excel

This week I had a request to show how to join text together from different columns in Excel. For this example, the Concatenate function in Excel works perfectly as it allows you to join strings of information together dynamically. The term “dynamically” means that if any data in the original location changes, our Concatenate function […]