Vlookup find next

%3CLINGO-SUB%20id%3D%22lingo-sub-2293698%22%20slang%3D%22en-US%22%3EVlookup%20find%20next%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2293698%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20function%20that%20will%20work%20like%20vlookup%2C%20but%20will%20return%20values%20from%20the%20next%20row%20in%20an%20array%20where%20the%20lookup_value%20recurs.%3C%2FP%3E%3CP%3EI%20have%20a%20table%20with%20a%20list%20of%20clients%20and%20their%20past%20appointments%20over%20a%206%20month%20period.%20I'm%20trying%20to%20list%20each%20individual's%20appointments%20in%20a%20separate%20worksheet%20with%20the%20aid%20of%20a%20vlookup%20type%20function%2C%20or%20whatever%20function%20will%20do%20the%20job.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2293698%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2293756%22%20slang%3D%22en-US%22%3ERE%3A%20Vlookup%20find%20next%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2293756%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2293865%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20find%20next%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2293865%22%20slang%3D%22en-US%22%3EI'm%20using%20a%20PC%2FWindows%208.1%20Office%20365%3C%2FLINGO-BODY%3E
Occasional Contributor

I need a function that will work like vlookup, but will return values from the next row in an array where the lookup_value recurs.

I have a table with a list of clients and their past appointments over a 6 month period. I'm trying to list each individual's appointments in a separate worksheet with the aid of a vlookup type function, or whatever function will do the job.

3 Replies
I'm using a PC/Windows 8.1 Office 365

@markjoyus 

You may use INDEX/MATCH with MATCH()+1