How to Perform a Two-Way LOOKUP Using INDEX MATCH MATCH

How To Perform a Two-Way Lookup Using INDEX MATCH MATCH

In this blog post, you will learn how to perform a two-way lookup using the functions INDEX MATCH MATCH. No, that’s not a typo; you will use the MATCH function twice. You’ll learn what a two-way lookup is, why it is useful, how to manage some of the error messages you may receive, and work through some examples.

Continue Reading →

Introduction to Excel Date Functions Part 3

Introduction to Excel Date Functions Part 3 - Twitter

This is the final post in a three-part series of blog posts introducing Excel date functions. In this final post, we look at a few of the less used, but still very useful date functions such as YEARFRAC and WEEKNUM, the DATEDIF function which is maintained for backwards compatibility reasons with Lotus 1-2-3. Additionally, for a bit of fun, we will look at the ROMAN function. As always, we work through some examples as we learn how these functions work.

Continue Reading →

Introduction to Excel Date Functions Part 2

Introduction to Excel Date Functions Part 2 Twitter

In this blog post, we’re going to look at some more date functions that enable you to identify the day, month, and year number in a date. We will also look at functions like the WEEKDAY, WORKDAY and NETWORKDAYS that can be used to calculate dates and the number of days between two dates, taking into account weekends and holidays.

Continue Reading →

Introduction to Excel Date Functions Part 1

Introduction to Excel Date Functions Part 1 Twitter

In this series of blog posts, I am going to show you how to output dates in different formats and walk you through some of the most commonly used date functions in Excel.

In the first blog post, we’re going to come to grips with how to format dates differently and have a look at a few useful and commonly used date functions to get you started.

Continue Reading →

How to Use the INDEX MATCH Functions to Find Data

How to Use the INDEX MATCH Functions to Find Data

In this blog post, we are going to take a look at how we can use a combination of the INDEX and MATCH functions, commonly referred to as INDEX MATCH, to find data in a range of cells.

Chances are that you are familiar with the VLOOKUP function. VLOOKUP is my favourite function. It can be used to quickly find data in a range of cells, but it does have its limitations. VLOOKUP uses the first column to search for a lookup value and can only return values to the right of the first column in the range of cells, but what if your lookup value isn’t located in the first column? This is where INDEX MATCH comes in. INDEX MATCH can return values to either the right or left of the column containing the lookup value, meaning it isn’t limited to using the first column in a range of cells to search for lookup values.

Continue Reading →

Page 3 of 7