I think that will work. We just to determine the recent date from the list of Date Mobilized under one equipment then it will return the value of Client, but i don't know how to do that. Using the same workbook you uploaded, can show how me for example the ATC0005 to retrieve the Client "E" on cell J6. Because the ATC0005 equipment has the recent mobilization date of 15-Jun-13.