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.
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 the different ways to structure your criteria when using the AVERAGEIFS function in Excel, along with the basic difference between AVERAGEIF & AVERAGEIFS.
In this tutorial we are going to look at a typical INDEX / MATCH combination formula but with a twist that concatenates both the lookup values and the arrays that are being looked into, making it an array formula.
In this tutorial we’ll take a look at the ADDRESS function and how to use it to dynamically change the SUM range based on a selection from a Data Validation drop down list. We’ll also incorporate the INDIRECT, ROW, and MATCH functions.
In this video we’ll take a look at how to modify previous videos I’ve done on pulling in photos tied to a drop down list by adding an option so that if nothing is selected, a blank cell will appear.