Excel Video 364 uses LARGE to find the last referral and OFFSET and MATCH to get the details about that referral. If you’ve watched the last several Excel Videos, using LARGE to calculate the last referral date will be pretty straight-forward. This time we’ll take the provider and last referral date to look up the referring physician, location, and specialty for the last referral.
If OFFSET and MATCH are new functions for you, you might find the series starting with Excel Video 87 helpful for OFFSET and Excel Video 179 helpful for MATCH. Stay tuned. I have a different array trick coming up next.