In this tutorial we are going to look at how we can do a lookup in an array by looking up the values in the far right column and returning the result from a column to the left. We are going to use the OFFSET and MATCH functions to accomplish this.
Tag Archives | VLOOKUP
In this tutorial we’ll take a look at how to do a VLOOKUP when you are only searching for a segment of the information in a specific column rather than the entire item.
In this tutorial we’ll take a look at how to create a simple dashboard using a combo box, a chart, an INDEX/MATCH combination formula and a few simple formatting concepts to easily evaluate the sales for any individual salesperson.
I’ve done three posts in the past on how to select photos using a drop down list. This series has turned out to be my most popular of all my posts. With all the questions and comments I get, there are two issues that are the most common errors that folks commit when setting up […]
In this tutorial we are going to do a lookup from one table that has multiple quantities for the same items, and ensure that we only pull each unique quantity once into another table sorted in a different order.
In this tutorial we’ll take a look at two ways to add a simple indicator to your data to track changes in values from day to day, or period to period. One way will use a nested IF statement, while the other will use a more rarely accessed function in Excel called the SIGN function.