Dave Bruns

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.

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...

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...

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.

In this video we'll look at a simple way to use VLOOKUP to group data into specific categories...

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.

In this video we'll look at how to troubleshoot a VLOOKUP formula designed to perform an approximate match...

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.

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.

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...