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