One way with an array formula that must be entered using ctrl+shift+enter
=INDEX(K:K,MATCH(MAX(IF($J$2:$J$22="field 4",$F$2:$I$22)),K:K))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Graham H" wrote in message
...
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.