VLOOKUP
VLOOKUP is a powerful function in Excel that I use all the time. It’s a bit complicated to start, but if you can master VLOOKUP, you can handle about 95% of the formulas Excel has to offer. VLOOKUP is a great way to combine data from two different sources. As long as both sources of data share a similar piece of information, VLOOKUP can quickly add data from fee schedules, lists of diagnosis codes, patient lists, and much more. Watch this series of Excel Videos and read the comprehensive article below. The more you use this function, the easier it will be.
Excel Video 61 Introducing VLOOKUP
Excel Video 61 is the first video in a new series covering VLOOKUP. If you’ve never seen VLOOKUP before,...
Excel Video 62 Multiple VLOOKUP Columns
Excel Video 62 uses the same example as Excel Video 61, adding the wrinkle that you can look up multiple...
Excel Video 63 Exact vs Approximate Match and IFERROR
Excel Video 63 introduces the difference between exact and approximate matches in the VLOOKUP formula. ...
Excel Video 64 Matching Data Types for VLOOKUP
Excel Video 64 warns about a common data mismatch problem when using VLOOKUP. When Excel looks up a value...
Excel Video 65 Concatenate to VLOOKUP
Excel Video 65 covers a common problem in VLOOKUP, what to do when there’s a problem with the data you’re...
Excel Video 66 When VLOOKUP is True
Excel Video 66 shows an example when you’ll want to find an approximate match (TRUE) instead of an exact...
Excel Video 67 VLOOKUP in Two Tables
Excel Video 67 is a practical example of how an anesthesiology practice uses VLOOKUP in two different tables...
Excel Video 68 Nesting Functions in VLOOKUP
Excel Video 68 shows how to nest functions, or put a function inside another function, in Excel. VLOOKUP is...
Excel Video 69 VLOOKUP x 2
Truth in advertising. Excel Video 69 is more complicated than most of these videos. I have a detailed table...
Excel Video 173 VLOOKUP Review
Excel Video 173 reviews VLOOKUP, one of the most powerful Excel functions for medical practice managers. I...
Excel Video 174 COLUMN with VLOOKUP
VLOOKUP’s a great function, but when you try to copy a VLOOKUP formula, watch out for a gotcha you’ll see...
Excel Video 175 HLOOKUP
Excel Video 175 tackles HLOOKUP. HLOOKUP is very similar to VLOOKUP, so similar in fact that we’ll use the...
Excel Video 176 ROW with HLOOKUP
In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula,...
