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 | MATCH
When using dynamic Data Validation, there are points when the item shown does not match the category listed> In this tutorial, I’ll show you how to write a formula to advise the user that another item needs to be chosen. We’ll use four functions to accomplish this: IF, OFFSET, MATCH and COUNTIF.
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.
In this tutorial we are going to explore a variation of the traditional INDEX/MATCH combination to extract and sum only a portion of a row or column within an array.
In this tutorial we’ll take a look at how to add a column with a formula outside of our PivotTable for project analysis that pulls results from a Table, then use Conditional Formatting to dress it up.
I recently received a request to use Conditional Formatting when performing two different comparisons on two data ranges. How I approached the task was WRONG! Read on to see how I finally got myself on the right track.