In this tutorial we are going to look at two ways of using VLOOKUP to pull data from a range of multiple columns at one time. One option will utilize an array formula using an array constant.
Tag Archives | VLOOKUP
In this tutorial we are going to look at how you can have multiple criteria as your lookup value with VLOOKUP. We’ll use the CHOOSE function with an array constant, and enter it as an array formula.
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.
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 […]