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.