Dynamic range lookup inside of an If statement

So I'm trying to return a value from a range that is created from specific conditions:

Client Name 1, Place for forumla , Date 1
Client Name 1, Place for forumla , Date 2
Client Name 1, Place for forumla , Date 3
Client Name 2, Place for forumla , Date 1
Client Name 2, Place for forumla , Date 2
Client Name 3, Place for forumla , Date 1
Client Name 3, Place for forumla , Date 2
Client Name 3, Place for forumla , Date 3

I want the function to select the most recent date for a range based on the client. I have written the following function: =if(G5=G4,"",MAX(Range formula Right Here). The fist if is simply saying if the previous cell matches, don't do the formula, then the second selects the most recent date from among the range, but I'm stuck on how to tell it to select a range. I only want it to select from the dates on the same row as the client.

Possible? I'd prefer an if statement instead of a VBA code.

Thanks!