by Nate Moore | Aug 15, 2011 | Functions
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...
by Nate Moore | Aug 10, 2011 | Functions
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...
by Nate Moore | Aug 8, 2011 | Functions
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...
by Nate Moore | Aug 3, 2011 | Functions
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...
by Nate Moore | Aug 1, 2011 | Functions
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...
