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 o...