Dave Bruns

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

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

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.