Perform a vlookup on a cell containing a formula?

Is it possible to perform a vlookup function using a cell which already contains a formula?

I am creating a spreadsheet which will list any complaints we have had against the work we have done for our customers. I have a separate worksheet for every customer within one workbook and want to pull together some information for all customers onto a summary worksheet. I already have a formula to countif there is actually a complaint and another to pull through only the most recent date of complaint onto my summary sheet. However I also have fields such as reference and status which I would like only to pull through onto the summary page, for the MOST RECENT DATE. Is this possible?

IE. My cell contains a MAX formula to find the most recent date from my range of cells. I then want to perform a vlookup using this 'most recent date value' to get data related to the current complaint (ie reference of the job/status).

I hope this all makes sense?

Thanks