Excel Video 173 reviews VLOOKUP, one of the most powerful Excel functions for medical practice managers. I initially covered VLOOKUP starting with Excel Video 61. Now that we have more background there are several more tricks we can use to make lookups even more powerful.
Today we’ll review the basics of VLOOKUP. VLOOKUP has four parameters.
What am I looking for?
What table has my information?
Once I find what I’m looking for, what column do you want Excel to return?
Am I looking for the closest value without going over (True) or an exact match (False).
If you haven’t used VLOOKUP in a while, you might find it helpful to go back and watch the series of videos starting with Excel Video 61. With that foundation, we’re going combine functions to add power to VLOOKUP starting next time. Thanks for watching.