Video
Why VLOOKUP is better than nested IFs
In this video we look at a few reasons why VLOOKUP is a better option than nested IF statements.Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Video
What to do when VLOOKUP returns NA
In this video we'll look at how to set up a VLOOKUP formula to avoid #N/A errors...Read more
Video
How to use VLOOKUP for wildcard matches
In this video we'll look at how to use VLOOKUP with wildcards. This is useful when you want to perform a lookup based on a partial match...Read more
Video
How to use VLOOKUP for approximate matches
In this video we look at how to configure VLOOKUP to look up values based on an approximate match. This is good for tax rates, postage, commissions, and the like.Read more
Video
How to use VLOOKUP
In this video learn how to use VLOOKUP to build a simple form to extract employee information from a table in about three minutes. VLOOKUP is a key Excel function.Read more
Video
How to troubleshoot VLOOKUP approximate match
In this video we'll look at how to troubleshoot a VLOOKUP formula designed to perform an approximate match...Read more
Video
How to replace nested IFs with VLOOKUP
In this video we look at how to replace a typical nested IF formula with a VLOOKUP formula. Compared to nested IF statements VLOOKUP is simpler, more transparent, and easier to adjust later. Read more
Video
How to group values with VLOOKUP
In this video we'll look at a simple way to use VLOOKUP to group data into specific categories...Read more
Video
How to use the MATCH Function for exact matches
In this video we look at how the MATCH function can find the position of an item in a list. This is a key idea in INDEX and MATCH formulas.Read more
Video
How to use MATCH to find approximate matches
In this video we'll look at how to use the MATCH function to find approximate matches. This is useful for things like calculating commissions, tax rates, and postage based on weight...Read more
Video
How to look things up with INDEX and MATCH
In this video we're going to combine INDEX and MATCH together to look things up. This is the core of all INDEX and MATCH formulas...Read more
Video
How to look things up with INDEX
In this video we look at how to configure INDEX to retrieve a value by row and column. This is the first half of the INDEX/MATCH equation.Read more
Video
How to do a two-way lookup with INDEX and MATCH
In this video we'll use MATCH to find the position of an item in a table and the INDEX function to retrieve the value at that position in a two-way lookup...Read more
Video
How to use HLOOKUP
In this video we'll look at how to use the HLOOKUP function. HLOOKUP works like VLOOKUP but is meant for data in a horizontal arrangement...Read more
Video
How to create a dynamic named range with a Table
In this video we'll look at how to create a dynamic named range with a Table. This is the simplest way to create a dynamic named range in Excel...Read more
Video
What is a dynamic named range
In this video we'll introduce the idea of a dynamic range and show you why you might want to use one. Spoiler: they adjust formulas automatically when data changes...Read more
Video
How to create a dynamic named range with OFFSET
In this video we'll look at how to create a dynamic named range using the OFFSET function; the most common way to create a dynamic named range with a formula...Read more
Video
How to create a dynamic named range with INDEX
In this video we'll look at how to create a dynamic named range with the INDEX function. INDEX is a non-volatile function, so it won't recalculate whenever a change is made to a worksheet...Read more
Video
How to use the SUMIFS function
In this video, we'll look at how to use the SUMIFS function to sum cells that meet multiple criteria in a set of data.
...Read more
Video
How to use the SUMIF function
In this video we'll look at how to use the SUMIF function to sum cells that meet a single criteria in a set of data.
...Read more
Video
How to use the SUM function
In this video we'll look at some tips and tricks for using the SUM function; one of the most widely used functions in Excel...Read more
Video
How to use the COUNTIFS function
In this video we'll look at how to use the COUNTIFS function to count cells that meet multiple criteria in a set of data.
...Read more
Video
How to use the COUNTIF function
In this video we'll look at how to use the COUNTIF function to count cells that meet multiple criteria in a set of data.
...Read more
Video
How to use the COUNT function
In this video we'll look at how to use the COUNT function to count cells that contain numeric data.
...Read more
Video
How to use the AVERAGEIFS function
In this video we'll look at how to use the AVERAGEIFS function to calculate an average from numbers that meet multiple criteria in a set of data.
...Read more
Video
How to use the AVERAGEIF function
In this video, we'll look at how to use the AVERAGEIF function to calculate an average from numbers that meet a single criteria in a set of data.
...Read more
Video
How to calculate maximum and minimum values
In this video we'll look at how to calculate minimum and maximum values in Excel using the MAX and MIN function.
...Read more
Video
How to calculate an average value
In this video we'll look at how to calculate an average from a set of data manually and with the AVERAGE function.
...Read more
Video
How to create a formula with nested IFs
In this video I'll show you how to create a formula that uses multiple, nested IF statements. This is a common technique to handle multiple conditions in a single formula...Read more
Video
If this OR that
In this video we look at how to combine the IF function with the OR and AND functions to test more than one condition at the same time.Read more