by Nate Moore | Jun 23, 2010 | VLOOKUP
Truth in advertising. Excel Video 69 is more complicated than most of these videos. I have a detailed table of partner’s equity transactions during the year and want to write one formula to pull specific rows and columns out of the detailed table to get a summary of...
by Nate Moore | Jun 21, 2010 | VLOOKUP
Excel Video 68 shows how to nest functions, or put a function inside another function, in Excel. VLOOKUP is a powerful function, but it is even more powerful if you can combine other Excel functions inside VLOOKUP. In Video 68, we have a table of patients and ICD-9...
by Nate Moore | Jun 16, 2010 | VLOOKUP
Excel Video 67 is a practical example of how an anesthesiology practice uses VLOOKUP in two different tables to make sure they aren’t missing any patients. Every month the practice compares a hospital report of patients treated to a practice report of patients treated...
by Nate Moore | Jun 14, 2010 | VLOOKUP
Excel Video 66 shows an example when you’ll want to find an approximate match (TRUE) instead of an exact match (FALSE) with VLOOKUP. The example shows some patient satisfaction scores from a survey. The survey answers range from 1 to 5, but the values go out to one...
by Nate Moore | Jun 9, 2010 | VLOOKUP
Excel Video 65 covers a common problem in VLOOKUP, what to do when there’s a problem with the data you’re looking up. In the video example, the accounting data has an account number and a department number. There are several departments using each account number, so...
