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 introduces the difference between exact and approximate matches in the VLOOKUP formula. ...

Excel Video 64 warns about a common data mismatch problem when using VLOOKUP. When Excel looks up a value...

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 shows an example when you’ll want to find an approximate match (TRUE) instead of an exact...

Excel Video 67 is a practical example of how an anesthesiology practice uses VLOOKUP in two different tables...

Excel Video 68 shows how to nest functions, or put a function inside another function, in Excel. VLOOKUP is...

Truth in advertising. Excel Video 69 is more complicated than most of these videos. I have a detailed table...

Excel Video 173 reviews VLOOKUP, one of the most powerful Excel functions for medical practice managers. I...

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 tackles HLOOKUP. HLOOKUP is very similar to VLOOKUP, so similar in fact that we’ll use the...

In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula,...