Select Page

## Excel Video 183 INDEX and MATCH as a Lookup

Excel Video 183 uses INDEX and MATCH to look up which payer has the highest and lowest reimbursement for a given CPT code. You’ll see in Excel Video 183 that I have a variety of statistical information about how different payers reimburse for a given CPT code. By...

## Excel Video 182 INDEX with Areas

There are two tricks to watch for in Excel Video 182. First, we’ll use the fourth section of the INDEX function so we can look in multiple areas in our spreadsheet for data. To look in multiple areas, first define each area in the first parameter of the INDEX...

## Excel Video 181 INDEX and MATCH x2

Excel Video 181 takes our INDEX and MATCH discussion one step further. Last time we used the MATCH function to calculate the row for INDEX to use. In this video, I’ll demonstrate how to use MATCH to provide both the row and column in an INDEX function. By using MATCH...

## Excel Video 180 INDEX and MATCH

Excel Video 180 combines INDEX and MATCH to create a powerful, flexible lookup tool. Now that we’ve seen both INDEX and MATCH in the last two Excel Videos, the trick is to combine the function to create a lookup tool. Remember INDEX asks for the area to look in and...

## Excel Video 179 MATCH

Watch Excel Video 179 to get started with MATCH, a flexible Excel function that can add power to other functions. The syntax of MATCH is: =MATCH(what to look for, where to find it, match type). What to look for (lookup value) and the range to find it are very similar...