VLOOKUP: Lookup the nth item (without helper columns)
In this series, Mastering VLOOKUP we have covered a lot of ground. But this post is one of the most fiendish of all. VLOOKUP, by its design, is intended to return the first match it finds. But, if we want the 2nd, 3rd or nth VLOOKUP it not so easy. Often people resort to helper … Read more