I hav a large array of data taking the format similar to below

Date Field Result
01/02/2008 Field 1 56
03/06/2007 Field 4 34
04/08/2008 Field 3 45
06/09/2008 Field 4 78
08/04/2007 Field 5 27
09/12/2006 Field 2 59

The dates are ongoing and a field may have a result covering one or more years and dates.
What I want to do is to enter Field 4 for example and get the latest result (78) for that.
This should also work if there is only one result for a field, and over the years there
may be three or four results for one field but I just want the latest. I thought MAX would
get the latest date but I cannot tie it together with the field name. Sorry dates are UK
format. I would value any guidance.