Vlookup find next

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.